CreateVirtualServerResources returns error 183 when you run SQL Server Service Pack Startup (821286)


The information in this article 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 SqlspN.log files (where N is the highest integer of the log file on each node). The SqlspN.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 : 3010This return code indicates that you must restart the node. To determine if the installation was successful, view the SqlspN.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 "Resolution" 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 SqlspN.log files and the log files show either of the following messages:
    • "Installation Succeeded - Reboot Required"

      -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 "Setup Failed to Perform Required Operations on the Cluster Nodes" Error

  • In Cluster Administrator, all the SQL Server resources come online without any problems.
  • The CSD version registry value that is located under the HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion registry key on each node has the correct service pack build number:
    • For SQL Server 2000 SP3: 8.00.760
    • For SQL Server 2000 SP2: 8.00.534
    For named instances, the value is located under the following registry key:

    HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\<InstanceName>\MSSQLServer\CurrentVersion
Modification Type:MinorLast Reviewed:4/7/2006
Keywords:kberrmsg kbtshoot kbprb KB821286 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.