[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

[Micke Palm]

Hello!

I got a problem there I can't reach the SQL server from another machine. The
scenenario is this
I run .NET and ASP sites on a server (ServerA) who need to reach a SQL
server on another server (ServerB). In .NET I can set it up in web.config
with <impersonate identify.../> and it works correct!
In classic ASP I've bigger problem to work it out.
Both servers are MS 2003 servers...

Do anyone have any clue about what's going on? If I use the SQL server on a
W2k server it works fine.

MS tell on their support about a bug, but how can it be a bug if .net works?

/regards, micke

 

[Bob Barrows]

Hello!

I got a problem there I can't reach the SQL server from another
machine. The scenenario is this
I run .NET and ASP sites on a server (ServerA) who need to reach a SQL
server on another server (ServerB). In .NET I can set it up in
web.config with <impersonate identify.../> and it works correct!
In classic ASP I've bigger problem to work it out.
Both servers are MS 2003 servers...

Do anyone have any clue about what's going on? If I use the SQL
server on a W2k server it works fine.

MS tell on their support about a bug, but how can it be a bug if .net
works?

Take a look at the following articles:
http://support.microsoft.com/?kbid=328306
http://support.microsoft.com/default.aspx?kbid=247931

This may also be relevant:
http://www.aspfaq.com/show.asp?id=2082


Bob Barrows

 

[Micke Palm]

Ok, thanks , but I've allready try them.
I try to move the database to another SQL server , but Server2003 and there
it works. What can be different in this server vs the other server?
The best for me was a easy way to set impersonate in ASP too coz it working
without any problem in .NET

/regards, micke