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

 

[Chris Jackson]

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.

 

[scorpion53061]

Check the database permissions. It won't work if they have not been assigned
properly.