By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,406 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

SQL Server does not exist or access denied.

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.