SQL Agent can not start

Hi,

I have a two node SQL Server cluster running under Virtual Server 2005
environment (Windows 2003 Server RD2, SQL 2005 Dev, sp1). After I
enabled Agent XPs, the SQL Agent still can't start. Here are the error
message from SQLAgent.out:

2007-01-06 10:56:54 - ! [298] SQLServer Error: 2, Named Pipes Provider:
Could not open a connection to SQL Server [2]. [SQLSTATE 08001]
2007-01-06 10:56:54 - ! [165] ODBC Error: 0, Login timeout expired
[SQLSTATE HYT00]
2007-01-06 10:56:54 - ! [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-01-06 10:56:54 - ! [000] Unable to connect to server '(local)';
SQLServerAgent cannot start
2007-01-06 10:57:25 - ! [298] SQLServer Error: 2, Named Pipes Provider:
Could not open a connection to SQL Server [2]. [SQLSTATE 08001]
2007-01-06 10:57:25 - ! [165] ODBC Error: 0, Login timeout expired
[SQLSTATE HYT00]
2007-01-06 10:57:25 - ! [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-01-06 10:57:25 - ! [382] Logon to server '(local)' failed
(DisableAgentXPs)
2007-01-06 10:57:26 - ? [098] SQLServerAgent terminated (normally)


What I have done:
1. verified remote connection is turned on.
2. Named Pipes is enabled.
3. registered server SPN

Since my SQL Server virtual server name is SQL2K5VS, I wonder why the
agent is trying to connect to (local) instead of the cluster virtual
server? Is this possible the problem?

Any help will be greatly appreciated.

Dan.

.

Relevant Pages

  • Re: accessing data mining model via web/PDA
    ... Is your OPENROWSET clause connecting to a SQL Server 2000 database? ... Is your SQL Server instance running on the same machine as your Analysis ... i need some> help for the connection string, let say to access the> mining model in the AS. ...
    (microsoft.public.sqlserver.datamining)
  • Re: VB Express SQL Express Remote Connection
    ... Yes I can connect using the SQL Server Management Studio Express Tool. ... I changed my connection to exactly what you specified and it connected. ... I can connect and create databases on the Remote Server ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to Direct connect with ActiveSync
    ... That won't work because you have a connection string that can't be correct. ... You're saying that the database is, but it's not; ... Server 2000, Visual Studio 2008. ... Again sorry if this should be in another form but you say that SQL Server ...
    (microsoft.public.sqlserver.ce)
  • .Net Scalability problem
    ... I finished a Great project using .Net and SQL Server and .Net Mobile ... Million concurrent users ... So I think that the MTC generate concurrent connection and per ...
    (microsoft.public.sqlserver.connect)
  • Re: Communication Link Failure Error
    ... On disconnection from the network, in my code I changed the connection ... string to use SQLOLEDB and sent a SQL query to SQL server which failed as ... unplug the network cable from the client machine and put the cable ...
    (microsoft.public.data.ado)