just for future refrence you probably don't want to give out ip addresses
and usernames and passwords.
With that error, I'd say either the IP or the username/password is worng.
-----Original Message-----
From: Mark Kothe
[mailto:mssqldba-ezmlmshield-x65251481.[Email address protected]
Sent: Sunday, December 31, 2006 7:24 AM
To: LazyDBA Discussion
Subject: Server does not exist or access denied
If this question is inappropriate for this group I apologize. With the
wealth of knowledge here I hoped it was a good place to start.
I get the following error
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
/Purchased/Wiring/TrackUsage.Asp, line 51
from the following code:
strconn = "Provider=SQLOLEDB;Data Source=192.168.254.100;Initial
Catalog=Mitchell1;Network=DBMSSOCN;User Id=AEPUsage;Password=AEPUsage"
set conn = server.createobject("adodb.connection")
strSQL=" Insert into AEPUsage (CurrentUser,CurrentPage,CurrentDate, Partno)
"
strSQL=strSQL & "
Values('"&CurrentUser&"','"&CurrentPage&"','"&CurrentDate&"','"&cPartNo&"')"
conn.open strconn ' <----this is line 51
The problem is that the code has worked for years, and now will only run for
3 day before the error starts.
This is a very small database running on SQL server 7 on W2K server. IIS is
on the same box.
When it fails I have tried restarting each individual service on the box
(MSSQL, IIS,etc.), but the only thing that fixes it is a complete restart of
the box. During the problem I can still login with QA using the same
credentials that the application uses on either the box, or another box on
the network.
Any thoughts on how to track what is causing the login to fail?
Unfortunately now I will have to wait 3 days to test any suggestions.
Mark
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page