I SURRENDER SQL Server Agent Fails to Start 2 Node Cluster
Joe
I am at my wits end now 3 days 5-6 Install / Un-Installs with trying
to get this 2 node Active/Passive to start the SQL Server Agent.
The Cluster Resource Registry entries are just like MS MSDN, Technet
and a 100 other articles have said they should look like.
Both Nodes
Environment: MS Server 2003 SP2
Dual Dual Core 2.28 processors
2 Gig Memory each
Quorum EMC iSCSI lun x
Data drive EMC iSCSI lun y
MSCS is setup and works great.
Failover of SQL server works great with the exception of the SQL
Server Agent.
Also I can connect to SQL server/instance remotely from my
workstation.
All the DOMAIN/GROUPS and Service DOMAIN/USER are in the groups and
the Local Machine Administraor group.
What is happening is that when the SQL Server Agent trys to connect to
the SQL Server Instance Servername/Instance it is not using the
VirtualServerName from the Sql Server Agent Resource but the Virtual
Cluster name.
This is the error log from the SQLagent.out
Notice the Servername/Instance line. Server is not the Virtual SQL
name which is I3PLCLSSQL and has a DNS Entry and can be connected
to SQL Server remotely.
2008-04-19 16:38:35 - ! [298] SQLServer Error: 65535, SQL Network
Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
[SQLSTATE 08001]
2008-04-19 16:38:35 - ! [165] ODBC Error: 0, Login timeout expired
[SQLSTATE HYT00]
2008-04-19 16:38:35 - ! [298] SQLServer Error: 65535, 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]
==============
2008-04-19 16:38:35 - ! [000] Unable to connect to server
'3PLSQLCLS\I3PLRPTSQL'; SQLServerAgent cannot start
2008-04-19 16:39:05 - ! [298] SQLServer Error: 65535, SQL Network
Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
[SQLSTATE 08001]
==============
2008-04-19 16:39:05 - ! [165] ODBC Error: 0, Login timeout expired
[SQLSTATE HYT00]
2008-04-19 16:39:05 - ! [298] SQLServer Error: 65535, 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]
2008-04-19 16:39:05 - ! [382] Logon to server '3PLSQLCLS\I3PLRPTSQL'
failed (DisableAgentXPs)
2008-04-19 16:39:06 - ? [098] SQLServerAgent terminated (normally)
Joe
WHOO HAAAA FOUND THE FIX FOR THIS DEVIOUS ISSUE LISTED BELOW.
Added VIRTUALSERVERNAME\INSTANCE as the value for the following
registry key on both nodes of the cluster.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\SQLServerAgent\ServerHost
With in place went to Cluster Admin and brought the Resource on line
without issue.
Failed to 2nd node, all came up perfectly
Failed back to 1st node and all started again perferctly.
After 4 days of searching FOUND IT.