Microsoft KB Archive/883732

= A SQL Server cluster resource goes to a &quot;failed&quot; state when you try to bring the resource online in SQL Server 2005 or in SQL Server 2000 =

Article ID: 883732

Article Last Modified on 4/6/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Standard Edition

-



Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
When you try to bring a SQL Server cluster resource online for a virtual instance of Microsoft SQL Server 2005 or of Microsoft SQL Server 2000, you may notice the following behavior:  The SQL Server cluster resource goes to a &quot;failed&quot; state and does not come online. You receive a combination of the following error messages on the computer that owns the SQL Server cluster resource.

Error message 1

An event that is similar to the following is in the system event log:

Date: 08/05/2004

Time: 1:11:19 AM

Source: ClusSvc

Category: Failover Mgr

Type: Error

Event ID: 1069

User: N/A

Computer: 

Description:

Cluster resource 'SQL Server ()' in Resource Group '' failed.

Error message 2

An error message that is similar to the following is in the Cluster log file:

00000644.00000944::2003/11/30-18:11:30.360 SQL Server : [sqsrvres] Unable to read the 'VirtualServerName' property. Error: d.

00000644.00000944::2003/11/30-18:11:30.360 SQL Server : [sqsrvres] OnlineThread: Error d bringing resource online.

Error message 3

Error messages that are similar to the following are in the SQL Server error log file:

2003-11-30 17:00:37.27 server Error: 17826, Severity: 18, State: 1

2003-11-30 17:00:37.27 server Could not set up Net-Library 'SSNETLIB'..

2003-11-30 17:00:37.27 spid13 Starting up database 'SPB'.

2003-11-30 17:00:37.27 spid12 Starting up database 'BD_MTA'.

2003-11-30 17:00:37.27 spid14 Starting up database 'BD_SPF'.

2003-11-30 17:00:37.27 server Error: 17059, Severity: 18, State: 0

2003-11-30 17:00:37.27 server Operating system error -1073723998: ..

2003-11-30 17:00:37.27 server Unable to load any netlibs.

2003-11-30 17:00:37.27 server SQL Server could not spawn FRunCM thread.





CAUSE
The resource-specific registry keys that correspond to the SQL Server cluster resource that you are trying to bring online are missing. This problem also occurs if the values that correspond to the resource-specific registry keys are not correct.



RESOLUTION
Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To resolve this problem, you must manually re-create the resource-specific registry keys that correspond to the SQL Server cluster resource. To do this, follow these steps:

 Click Start, click Run, type Regedit, and then click OK.</li> In Registry Editor, locate and select the following registry key:

</li> Create the following registry values in the  registry key:

For a default instance of SQL Server:  InstanceName

Value Name: InstanceName

Value Type: REG_SZ

Value Data: MSSQLSERVER</li> VirtualServerName

Value Name: VirtualServerName

Value Type: REG_SZ

Value Data: <Name of the virtual SQL server></li></ul>

For a named instance of SQL Server:  InstanceName

Value Name: InstanceName

Value Type: REG_SZ

Value Data: <SQL Server instance name corresponding to the virtual server></li> VirtualServerName

Value Name: VirtualServerName

Value Type: REG_SZ

Value Data: <Name of the virtual SQL server></li></ul> </li> Quit Registry Editor.</li></ol>

After you create the resource-specific registry keys, you can bring the SQL Server cluster resource online successfully.

If you notice that a SQL Server Agent cluster resource cannot be brought online, you must create the same set of resource-specific keys that correspond to the SQL Server Agent cluster resource.

<div class="moreinformation_section">

MORE INFORMATION
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

810056 You must use resouce-specific registry keys for SQL Server cluster resouces

Keywords: kberrmsg kbtshoot kbregistry kbresource kbprb kbclustering kbevent kbsql2005cluster KB883732

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.