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:
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:
In Control Panel, double-click Administrative Tools , and then double-click Cluster Administrator .
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.
Right-click the SQL Server Agent resource, and then click Delete.
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
- Recreate the SQL Server Agent resource using the steps below:
Right click on the SQL Server group, point to New and then click Resource.
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.
Include the original node on the cluster as possible resource owner.
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.
Add the SQL Server Resource as a dependency for the newly created SQL Server Agent resource.
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
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.
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.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
for other considerations.
Article ID: 2102055 - Last Review: September 8, 2010 - Revision: 3.0
- Microsoft SQL Server 2008 Developer
- Microsoft SQL Server 2008 Enterprise
- Microsoft SQL Server 2008 Standard
- Microsoft SQL Server 2008 Enterprise Evaluation