Cannot Add a second node to an SQL Server 2008 Failover Cluster
Background: i am creating a failover cluster on Windows Server 2008 SP2 64-bit with SQL Server 2008 SP1 64-bit.
Problem: i added the first node and it went fine and when i tried to add the second node, i got this error: Failover instance MSSQLSERVER cluster group not found
Reasoning: when you check the registry for HKEY_LOCAL_MACHINE\Cluster\ResourceTypes. you will not find the “SQL Server Agent”. which means that the Agent is not part of the cluster.
Solution:
1. Open a command prompt and type this command to add a resource type:
cluster restype "SQL Server Agent" /create /DLL:sqagtres.dll
2. Change all the values from 2 to 1 in registery under:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft Microsoft SQL Server\MSSQL10.MSSQLSERVER\ConfigurationState
3. In the Failover Cluster Management used Add Resource to add the SQL Server Agent resource.
4. Right-clicked on the resource and clicked on Properties. Added Virtual Server name (YOUR VIRTUAL NAME) and Instance name (MSSQLSERVER)
5. Add the SQL Server service as dependency for SQL Server Agent Service. and click ok!
6. Right click the resource and click on “bring this resource online”
7. once, the resource is online, you can go ahead and add the the second node
Logs: for your references, i am add the logs
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): 2064843076
Exit facility code: 787
Exit error code: 324
Exit message: Failover instance 'MSSQLSERVER' cluster group not found.
Start time: 2009-12-06 05:42:35
End time: 2009-12-06 05:46:51
Requested action: AddNode
Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20091206_054153\Detail.txt
Exception help link: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.2531.0%26EvtType%3d0xAB730BE3%400xE9BC3D64
Cluster properties:
Machine name: XXXXXX
Product Instance Instance ID Feature Language Edition Version Clustered
Machine name: XXXXXX
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Database Engine Services Enterprise Edition 10.0.1600.22 Yes
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER SQL Server Replication Enterprise Edition 10.0.1600.22 Yes
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Full-Text Search Enterprise Edition 10.0.1600.22 Yes
Sql Server 2008 Management Tools - Basic 1033 Enterprise Edition 10.1.2531.0 No
Sql Server 2008 Management Tools - Complete 1033 Enterprise Edition 10.1.2531.0 No
Machine Properties:
Machine name: XXXXXX
Machine processor count: 16
OS version: Windows Server 2008
OS service pack: Service Pack 2
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: Yes
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Package properties:
Description: SQL Server Database Services 2008
SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 0
Installation location: C:\SQLServer2008_FullSP1\x64\setup\
Installation edition: ENTERPRISE
User Input Settings:
ACTION: AddNode
AGTSVCACCOUNT: <empty>
AGTSVCPASSWORD: *****
ASSVCACCOUNT: <empty>
ASSVCPASSWORD: *****
CONFIGURATIONFILE:
CUSOURCE:
FAILOVERCLUSTERGROUP: SQL Server (MSSQLSERVER)
FAILOVERCLUSTERNETWORKNAME: WTHSDBCL0B
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: *****
HELP: False
INDICATEPROGRESS: False
INSTANCENAME: MSSQLSERVER
PCUSOURCE:
PID: *****
QUIET: False
QUIETSIMPLE: False
SQLSVCACCOUNT: <empty>
SQLSVCPASSWORD: *****
X86: False
Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20091206_054153\ConfigurationFile.ini
Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: SQL Server Replication
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Full-Text Search
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Management Tools - Complete
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Feature: Management Tools - Basic
Status: Failed: see logs for details
MSI status: Passed
Configuration status: Passed
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20091206_054153\SystemConfigurationCheck_Report.htm
Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented
Exception type: System.InvalidOperationException
Message:
Failover instance 'MSSQLSERVER' cluster group not found.
Data:
DisableWatson = true
Stack:
at Microsoft.SqlServer.Configuration.Agent.Util.GetClusterGroup(ServiceContainer ctx, String instanceName)
at Microsoft.SqlServer.Configuration.Agent.Util.GetClusterActiveNode(ServiceContainer ctx, String instanceName)
at Microsoft.SqlServer.Configuration.Agent.AgentConfigurationPublic.Calculate()
at Microsoft.SqlServer.Configuration.PublishedProperties.Calculate()
at Microsoft.SqlServer.Configuration.PublishedProperties.Calculate()
at Microsoft.SqlServer.Configuration.InstallWizardFramework.ConfigurationController.LoadData()
at Microsoft.SqlServer.Configuration.InstallWizard.ServicesController.LoadData()
at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardPageHost.PageEntered(PageChangeReason reason)
at Microsoft.SqlServer.Configuration.WizardFramework.UIHost.set_SelectedPageIndex(Int32 value)
at Microsoft.SqlServer.Configuration.WizardFramework.NavigationButtons.nextButton_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Comments
Anonymous
January 28, 2010
Is this work suppose to be performed on the primary node or the node you are wanting to add? I am assuming the primary node, since SQL Server is not installed on the node I want to add due to this error, but wanted to make sure. ThanksAnonymous
April 22, 2010
Do it on the primary node. Easy to do and after that SQL Cluster works fine on both nodes. No need to unisntall - reinstall.Anonymous
August 05, 2010
I've tried by the suggested way, but it's uselessAnonymous
October 01, 2010
Worked like a charm. Thanks!Anonymous
March 09, 2011
I've run into this on a few cluster installs when there are issues bringing the sql netname online. This has worked for me multiple times and thanks a ton for posting it!Anonymous
October 06, 2011
It working fine after completed your steps for creating SQL agent service.