strange sql connection prob

  • Thread starter Thread starter Tim Almond
  • Start date Start date
T

Tim Almond

Already posted to sql server group but maybe some help here....

If I run my application, I get a 'database does not exist'. If I then go
onto the machine with the database on (different machine) and log in to
query analyser, I can then go back to the web browser, it connects fine.

Three machines involved...
My PC
web server
db server

Order of events is...
go onto my PC, try and connect to web server via HTTP... fails with unknown
DB
do a remote connection to db server, log in
go back to my PC, try and connect to web server via HTTP... works fine.

It seems strange, like logging into the DB starts it polling itself as alive
or something.

Can someone please help? Would putting in the IP address be better than the
server name?
 
Hi Curt,

The SQL Connection string is
server=1.1.1.1;database=dname;uid=****;password=********* with the names
changed to protect the guilty.

It's intermittent. Sometimes it's fine, sometimes not, and I'm wondering if
it's the network as the test network is OK.
 
Back
Top