PLEEEEEASE HELP
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)
Bookmarks