473,327 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

SQL Server does not exist or access denied.

gg
hi group,

i previously have a single machine development environment on server03
(w2K3, stand alone, SQL2K).
i configured it so that my app is using "NT AUTHORITY\NETWORK SERVICE" to
access to the database it and it worked just so fine.

now, i am installing my asp.net app and database to a new production
environment.
my asp.net apps goes on server01 (w2k3, .net 1.1, domain controller).
my database on server02 (w2K3, stand alone, SQL2K).
now i get an error "SQL Server does not exist or access denied".
how do i setup so that my apps on server01 gets to access the database on
server02?

any help will be appreciated.

tnx!

GG
Nov 15 '05 #1
2 4392
Set up your ASP.NET process to use a domain account rather than a local
account. You can do this by editing your machine.config, or by using
impersonation on ASP.NET, having anonymous authentication, and then setting
IIS to use that domain account as its process identity. Alternately, you
could use authentication and set up permissions for all of your users on the
SQL server.

--
Chris Jackson
Software Engineer
Microsoft MVP - Windows XP
Windows XP Associate Expert
--
"gg" <gg**********@hotpop.com> wrote in message
news:OS**************@TK2MSFTNGP10.phx.gbl...
hi group,

i previously have a single machine development environment on server03
(w2K3, stand alone, SQL2K).
i configured it so that my app is using "NT AUTHORITY\NETWORK SERVICE" to
access to the database it and it worked just so fine.

now, i am installing my asp.net app and database to a new production
environment.
my asp.net apps goes on server01 (w2k3, .net 1.1, domain controller).
my database on server02 (w2K3, stand alone, SQL2K).
now i get an error "SQL Server does not exist or access denied".
how do i setup so that my apps on server01 gets to access the database on
server02?

any help will be appreciated.

tnx!

GG

Nov 15 '05 #2
Check the database permissions. It won't work if they have not been assigned
properly.

"gg" <gg**********@hotpop.com> wrote in message
news:OS**************@TK2MSFTNGP10.phx.gbl...
hi group,

i previously have a single machine development environment on server03
(w2K3, stand alone, SQL2K).
i configured it so that my app is using "NT AUTHORITY\NETWORK SERVICE" to
access to the database it and it worked just so fine.

now, i am installing my asp.net app and database to a new production
environment.
my asp.net apps goes on server01 (w2k3, .net 1.1, domain controller).
my database on server02 (w2K3, stand alone, SQL2K).
now i get an error "SQL Server does not exist or access denied".
how do i setup so that my apps on server01 gets to access the database on
server02?

any help will be appreciated.

tnx!

GG

Nov 15 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jay Chan | last post by:
We have just installed a SQL Server 2000 (SP 3A) onto a computer that has Windows-2003 Server on it. Now, we cannot get access to that database server from other computers. Seem like this may be an...
2
by: george r smith | last post by:
Gentlemen, I know that this problem has happened before and I searched and tried all solutions but problem is not solved. I install asp.net community starter kit with some help from this...
6
by: Bob | last post by:
Having trouble getting started. I created an instance of MSDE called VSDOTNET on a computer with the name of sysdev. Using MS SQL Web Adminstrator I created a database called temp with a...
3
by: Matthew Louden | last post by:
I attempt to connect ASP.NET application with SQL Server using ADO.NET. I just open a connection, and it had run-time error in line 34: cn.open(): SQL Server does not exist or access denied....
3
by: Olivogt | last post by:
Hello, I was just puting an application on the web server but it did not work as usual... - I do develop on my notebook and move released applications to the Web server - both have Sql Server...
9
by: Steven Ung | last post by:
Hello all, I'm having the following error dump from an ASP.net application. The program is to calculate MRP and it involves complex queries looping thru hundreds of records in an few SQL 2000...
1
by: ssp | last post by:
G'Day All, I have a web application sitting on my laptop and a Sql Server 2000 database on our INTRANET server running Windows 2003. Up until recently I was able to access the database using my...
2
by: Johan Johansson (Sweden) | last post by:
I can't connect to our database (seperate database server) from within my webservice. I cannot understand why.!!! * I have configured IIS not to allow anonymous access and to use "windows...
1
by: Atia Amin | last post by:
Hi, I am a new member. Hello to every one. I am new in ASP.NET area. I wrote an ASP.NET web application which was running ok with my old laptop. Currently I have given a new laptop. Now I copied...
1
by: vamshika | last post by:
hi, I got a serious Problem. I get "Server does not exist or access denied" with 80004005 as the error code. the win2003 server uses all the latest components(like iis6,jet..etc) and is upto date....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.