Ads

28 March 2011

A SQL Server cluster resource goes to a "failed" state when you try to bring the resource online in SQL Server

http://support.microsoft.com/kb/883732/en-us

=====================================================================================
1. Click Start, click Run, type Regedit, and then click OK.
2. In Registry Editor, locate and select the following registry key:

HKEY_LOCAL_MACHINE\Cluster\Resources\\Parameters
3. Create the following registry values in the Parameters registry key:

For a default instance of SQL Server:
* InstanceName

Value Name: InstanceName
Value Type: REG_SZ
Value Data: MSSQLSERVER
* VirtualServerName

Value Name: VirtualServerName
Value Type: REG_SZ
Value Data:
For a named instance of SQL Server:
* InstanceName

Value Name: InstanceName
Value Type: REG_SZ
Value Data:
* VirtualServerName

Value Name: VirtualServerName
Value Type: REG_SZ
Value Data:
4. Quit Registry Editor.

=====================================================================================

No comments:

Post a Comment