Microsoft KB Archive/821286

= CreateVirtualServerResources returns error 183 when you run SQL Server Service Pack Startup =

Article ID: 821286

Article Last Modified on 4/7/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition

-



SYMPTOMS
Although SQL Server Service Pack Setup has completed all necessary upgrade operations for a virtual server, you may receive the following error message when you run the Setup program:

An error occurred while creating virtual server resources for clustering. Cannot create a file when that file already exists

The SQL Server Service Pack installation log file (Sqlsp.log) indicates that CreateVirtualServerResources returned error 183: 13:39:25 Begin Action : CreateVirtualServerResources

13:39:25 Begin: BeforeFTS

13:39:25 Begin Action : EnumerateNodes

13:39:25 End Action : EnumerateNodes

13:39:25 End: AfterFTS 13:39:26 End Action : CreateVirtualServerResources

13:39:26 CreateVirtualServerResources returned: 183

The unattended Setup programs on each node of the cluster create Sqlsp .log files (where  is the highest integer of the log file on each node). The Sqlsp .log files show that the installation was successful. However, the section of the Sqlsp.log file about remote setups shows the following text : 16:44:31 Installation return status on TESTNODEN1 : 0

16:44:31 Installation return status on TESTNODEN2 : 0

Note In some situations, you may see a non-zero return code. A non-zero return code for installations on individual nodes of the virtual server does not mean that the Setup program has failed. In the following example, 3010 is a non-zero return code: 16:44:31 Installation return status on TESTNODEN2 : 3010

This return code indicates that you must restart the node. To determine if the installation was successful, view the Sqlsp .log file to make sure that you received an “Installation Succeeded” or “Installation Succeeded - Reboot Required” message.



CAUSE
This problem may occur for several reasons. This problem does not affect the functionality and integrity of the upgrade process if the conditions in the &quot;Resolution&quot; section are true.



RESOLUTION
You can safely ignore these error messages if all the following conditions are true:  All the nodes of the virtual server have the latest Sqlsp .log files and the log files show either of the following messages:  &quot;Installation Succeeded - Reboot Required&quot;

-or- “Installation Succeeded”

For more information about the Setup program and the log files, see the “Understanding the SQL Server 2000 Virtual Server Setup Process” section in the following Microsoft Knowledge base article:

321063 HOW TO: Troubleshoot the &quot;Setup Failed to Perform Required Operations on the Cluster Nodes&quot; Error

 In Cluster Administrator, all the SQL Server resources come online without any problems. The CSD version registry value that is located under the  registry key on each node has the correct service pack build number:  For SQL Server 2000 SP3: 8.00.760</li> For SQL Server 2000 SP2: 8.00.534</li></ul>

For named instances, the value is located under the following registry key:

</li></ul>

Additional query words: CreateVirtualServerResources error 183

Keywords: kberrmsg kbtshoot kbprb KB821286

-

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

© Microsoft Corporation. All rights reserved.