Is the SQL Server Service running? If that's not it, is the SQL Server
Browser service running? Have any credentials recently changed on any of your
SQL service accounts that weren't changed in the Log On tab under the service
properties?

John Eisbrener
SQL Database Administrator
Capitol Insurance Companies

-----Original Message-----
From: Norm Milan
[mailto:mssqldba-ezmlmshield-x59152315.[Email address protected]
Sent: Tuesday, November 27, 2007 2:40 PM
To: LazyDBA Discussion
Subject: Agent in a pickle

Can anyone offer advice on this?:


2007-11-27 13:27:06 - ! [298] SQLServer Error: 2, Named Pipes Provider:
Could not open a connection to SQL Server [2]. [SQLSTATE 08001]
2007-11-27 13:27:06 - ! [165] ODBC Error: 0, Login timeout expired
[SQLSTATE HYT00]
2007-11-27 13:27:06 - ! [298] SQLServer Error: 2, An error has occurred
while establishing a connection to the server. When connecting to SQL
Server 2005, this failure may be caused by the fact that under the
default settings SQL Server does not allow remote connections. [SQLSTATE
08001]
2007-11-27 13:27:06 - ! [000] Unable to connect to server '(local)';
SQLServerAgent cannot start


Thanks in advance....

n



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