You are currently offline, waiting for your internet to reconnect

You get "Failover instance 'MSSQLSERVER' cluster group not found" when you try to add a new node to a single node SQL Server Failover cluster.

When you try to add a node to an existing single node SQL Server 2008 Failover Cluster using Add node to a SQL Server failover cluster feature of SQL Server 2008 setup program, you may encounter the following error message:

Failover instance 'MSSQLSERVER' cluster group not found.

Additionally you may notice that in the SQL Server Group in the Cluster Administrator or the Failover Cluster Management application, either the SQL Server Agent resource is not present or is created as a generic resource.

You may notice a message that is similar to the following in the Summary.txt log file:

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.
  Requested action:          AddNode
Note: You can find the summary log at the following location: 

%ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\LOG\Summary.txt

Note:You may notice that though the SQL Agent resource is not present in the cluster, the SQL Agent service will still be present if you look under Services applet.

The problem occurs because the SQL Server setup program cannot find the SQL Server Agent resource in the cluster either because it is not created or it has been created with an incorrect Resource Type. You can experience this problem when the initial installation of SQL server single node cluster is either incomplete or corrupt.


You should examine the SQL Server setup logs for the original installation (Single node setup) to determine the corrective action that needs to be taken for the failed or corrupt installation.

For example, if the setup logs indicate that you need to repair or uninstall the problematic instance, you can refer to the following topics in Books Online:

For further information on how to troubleshoot SQL Server setup issues refer to the following article in Microsoft Knowledge Base:

  • 955396 How to troubleshoot SQL Server 2008 Setup issues


To work around this problem, you can manually create the SQL Server agent resource using the procedure below:

For Windows Server 2003 environment use the following procedure:

  1. In Control Panel, double-click Administrative Tools , and then double-click Cluster Administrator . 
  2. In the Cluster Administrator snap-in, expand Groups , and then click the SQL Server cluster resource group that was installed for the SQL Server 2008 failover cluster. 
  3. Right-click the SQL Server Agent resource, and then click Delete. 
  4. Create the correct SQL Agent Resource type. To do so, Open  a command prompt and type the following command to add the SQL Server Agent resource type to the cluster
    cluster restype "SQL Server Agent" /create /DLL:sqagtres.dll
  5. Recreate the SQL Server Agent resource using the steps below:
    1. Right click on the SQL Server group, point to New and then click Resource.
    2. In the Name box, type SQL Server Agent. In the Resource type box, click SQL Agent Resource, and then click Next.
      Note: The name is case sensitive unless you are on CU3 or above for SQL Server 2008 RTM.
    3. Include the original node on the cluster as possible resource owner.
    4. Right click the newly created SQL Server Agent resource and fill in the following two parameters:
      Specify the virtual server name of the SQL Instance.
      Specify the Instance name.
    5. Add the SQL Server Resource as a dependency for the newly created SQL Server Agent resource.
  6. Open Registry Editor and navigate to one of the following locations and ensure that all the values are set to 1. If not, manually edit the respective values and set them to 1. This will ensure that the configuration state for all the SQL features is set to 1, indicating that the feature is installed and configured. A value greater than 1 indicates a failure either during the installation or configuration phase of the original setup.

    For default instance:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\ConfigurationState

    For a named Instance
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft Microsoft SQL Server\MSSQL10.INSTNAME\ConfigurationState
  7. Bring the newly created SQL Agent Resource online.

Once the newly created resources comes online successfully, you can reattempt the AddNode operation that was failing.

Note:In Windows Server 2008 and Windows Server 2008 R2 environments, you can use Failover Cluster Management application to go through the above procedure. The application can be found under Administrative Tools in Control Panel applet.

More Information

For scnearios where the SQL Server Agent resource is missing in the cluster administrator, you can see the following call stack in the Detail.txt  setup log file:

Exception type: System.InvalidOperationException
        Failover instance 'MSSQLSERVER' cluster group not found.
        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
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 2102055 - Last Review: 09/08/2010 19:08:00 - Revision: 3.0

Microsoft SQL Server 2008 Developer, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 Enterprise Evaluation

  • KB2102055