RE: Server does not exist or access denied

RE: Server does not exist or access denied

 

  

Thanks, I'll try it. Takes 3 days for it to break, so I'll let you know
then.

Mark

-----Original Message-----
From: J Eric Smith
[mailto:mssqldba-ezmlmshield-x38544651.[Email address protected]
Sent: Sunday, December 31, 2006 9:38 AM
To: LazyDBA Discussion
Subject: RE: Server does not exist or access denied


You need to specify the port in a tcp/ip connection. If your server is on a
port other than the default 1433, then you will have to change. Not sure if
Network without "Library" is acceptable.


Try this connection string:

strconn = "Provider=SQLOLEDB;Data Source=192.168.254.100,1433;Initial
Catalog=Mitchell1;Network Library=DBMSSOCN;User
Id=AEPUsage;Password=AEPUsage"

eric


-----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



---------------------------------------------------------------------
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

Spam tests failed: None





MS Sql Server LazyDBA home page