Database Connection Issues

[bh]

I have an ASP.NET page, created in VS.NET 2003 which connects to a SQL
Server 2000 Database on our network, using a connection string, as follows:

Dim SQLConnString As String = "data source=SERVERNAME;initial
catalog=DB;User ID=MyWebUser;Password=WebUserPassword"

The server is on our network, but a different machine from both of the web
servers I'm trying.

Web Server 1: When I run this from Visual Studio (running on my laptop), it
works fine every time.

Web Server 2: When I run this from another web server within our network,
SOMETIMES it works fine, and other times I get:

SQL SERVER DOES NOT EXIST OR ACCESS DENIED

If I go back & run it from Visual Studio on my laptop, again, it seems to
SOMETIMES temporarily correct the issue from our other web server other
times it has no effect.

Does anyone have any idea as to what might be causing this? Thanks in
advance.

BH

 

[Kevin Spencer]

Try using the IP address of the server. It may be a name resolution issue.
If so, the IP address will clear it up.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Chicken Salad Alchemist

What You Seek Is What You Get.

 

[bh]

Nope. That just caused the same error on the working copy, running straight
out of Visual Studio, from the laptop. Any other ideas?

Thanks for trying,
BH

 

[prabhupr]

1. Try using IP Address
2. Try changing the Network connectivity (TCP/IP, Named Pipes...)

 

[neilmcguigan]

don't forget the instance name if you have one:

ServerName\InstanceName

for sql express, it's:

ServerName\SqlExpress (um, i think )