Share via


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.  Thanks

  • Anonymous
    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 useless

  • Anonymous
    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.