SQL Server does not Exist or Access is denied....

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi,

I have 2 ASP.NET projects. In the Global.asax I open a
SQLReader to a recordset and for each record I create an
object in the other project... this object does another
hit to the SQL Server...

I am getting the error 'SQL Server does not exist or
Access is denied' on the second database hit...

Just to twist things... This all works on WinXP accessing
a SQL Server on Win2003.

When I tried to migrate the code to the same Win2003
server, I get this error... So running locally we get the
errors...

PLEASE PLEASE PLEASE ... Any Ideas?

Thanks in Advance...

Mark
 
Hi Mark,

Did you check if asp.net account on w2003 server has access to sql server?
Do you use windows authentication, do you?
 
Hi Miha,

Thanks for your response...

We are using mixed mode authentication. So in our
web.config we have a user name and password...

How do I check if my ASP.NET user has access to SQL
Server? Do I add it as a user in SQL Server using
Enterprise manager?

Thanks in advance,

Mark
 
Hi Miha,

Thanks for your response...

We are using mixed mode authentication. So in our
web.config we have a user name and password...
Click to expand...

This should be ok then.
How do I check if my ASP.NET user has access to SQL
Server? Do I add it as a user in SQL Server using
Enterprise manager?
Click to expand...

No need if you use sql server authentication.
Hmm, could be that your connection string is wrong?
 
Hi Miha,

Thanks again for your response. I found the problem...
what we had was two different projects accessing the
database in slightly different ways...

So when I got them accessing the DB in the same manner...
there was no problems...

Thanks again,

Mark
 
Back
Top