Go Back   TechArena Community > Technical Support > Computer Help > Windows Server > Windows Server Help
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



SQL ENT 2005 on 2 node ENT 12003 cluster SQL Server Agent will not start

Windows Server Help


Reply
 
Thread Tools Search this Thread
  #1  
Old 20-04-2008
Joe
 
Posts: n/a
SQL ENT 2005 on 2 node ENT 12003 cluster SQL Server Agent will not start

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)

Reply With Quote
  #2  
Old 20-04-2008
Joe
 
Posts: n/a
Re: SQL ENT 2005 on 2 node ENT 12003 cluster SQL Server Agent will not start

On Sat, 19 Apr 2008 23:32:44 -0400, Joe <jmowry@joment.com> wrote:

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.


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

Reply With Quote
  #3  
Old 20-04-2008
Ryan Sokolowski [MVP]
 
Posts: n/a
Re: SQL ENT 2005 on 2 node ENT 12003 cluster SQL Server Agent will not start

Not really sure you should have needed to do this, as installing SQL 2005 on
a properly setup 2003 cluster is really *almost* automatic, but I'm happy
that it works for you now! :-)

Let us know if you have any other issues...

--
Ryan Sokolowski
MVP - Clustering
MCSE, CCNA, CCDA, BCFP

"Joe" <jmowry@joment.com> wrote in message
news:s0jl045488v9rk1etql9o4d5f0h36p5398@4ax.com...
> On Sat, 19 Apr 2008 23:32:44 -0400, Joe <jmowry@joment.com> wrote:
>
> 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.
>
>
>>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)


Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Windows Server > Windows Server Help
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "SQL ENT 2005 on 2 node ENT 12003 cluster SQL Server Agent will not start"
Thread Thread Starter Forum Replies Last Post
Live Migration of Failover Cluster Node (SQL) causes cluster halt Mr. Joe Windows Server Help 1 21-05-2011 12:41 AM
New cluster - fail to add node 2 to the cluster, Error 0x800706ba: The RPC server is unavailable stepws Windows Server Help 1 23-04-2011 06:14 PM
could not start the cluster service on node 2 Rami Khatib Windows Server Help 4 19-06-2009 09:07 PM
Windows 2008 cluster for SQL server 2005 cluster Roger Windows Server Help 2 21-05-2008 10:16 AM
Failover behaviour on a 2 node cluster Ariel Windows Server Help 9 30-04-2005 02:16 AM


All times are GMT +5.5. The time now is 10:36 AM.