Microsoft KB Archive/320524

= BUG: The Setup program of SQL Server 2000 Service Pack 2 or a later version may stop responding in a Windows clustering environment if there is an offline database =

Article ID: 320524

Article Last Modified on 9/2/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 3a
 * Microsoft SQL Server 2000 Service Pack 3
 * Microsoft SQL Server 2000 Service Pack 2

-



This article was previously published under Q320524



BUG #: 356934, 356933 (SHILOH_BUGS)



SYMPTOMS
When you upgrade a virtual instance of Microsoft SQL Server 2000 to SQL Server 2000 Service Pack 2 (SP2) or a later version in a Windows Clustering environment, and one or more databases in your instance of SQL Server are offline, the Setup program may stop responding, and you may receive the following error message:

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

Additionally, detailed error messages are logged in the Setup log files (Sqlsp.log and Sqlclstr.log). These files are located in the Windows installation folder.

The Sqlsp.log file indicates that CreateVirtualServerResources returned error 183:

20:22:25 Begin Action : CreateVirtualServerResources

20:22:25 Begin: BeforeFTS

20:22:25 Begin Action : EnumerateNodes

20:22:25 End Action : EnumerateNodes

20:22:25 End: AfterFTS

20:22:35 End Action : CreateVirtualServerResources

20:22:35 CreateVirtualServerResources returned: 183

20:28:38 Begin Action : ClusterErrorCleanup

The Sqlclstr.log file indicates that the cause of the failure is the offline database. In this sample log file, the pubs database is indicated as the offline database:

about to open cluster

calling ClusterGetComputerNames

ClusterGetComputerNames: m_LocalComputerName=[]

ClusterGetComputerNames: calling GetComputerName

ClusterGetComputerNames: m_LocalComputerName=[GXPRO]

ClusterGetComputerNames: calling ClusterOpenEnum

ClusterGetComputerNames: calling ClusterEnum[0]

ClusterGetComputerNames: calling ClusterEnum[1]

called ClusterGetComputerNames, status=0x0

cConnectString=&quot;ODBC;DSN='';DRIVER={SQL Server};SERVER=VSQL;DATABASE=master;Trusted_Connection=yes&quot;

Database 'pubs' cannot be opened because it is offline.

[sqlclusterSetup.cpp:1295] : 183 (0xb7): DoClusterSetupWork

Note In the Japanese version of SQL Server 2000 Enterprise Edition SP2, unlike the English version, the Sqlclstr.log file does not include an error message that refers to the offline database. This is the cause of the failure.



CAUSE
This problem occurs because Setup program cannot access the database.

During installation in a Windows Clustering environment, Setup program must query the user databases to make sure that all the database files are on disk resources that have the correct dependencies and the virtual SQL Server resource. The virtual SQL Server resource is required for the failover support. When a database is offline, Setup program cannot access the database.



WORKAROUND
To work around this problem, bring the inaccessible database online, and then rerun the service pack Setup program.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
You do not experience this problem during SQL Server SP1 Setup. During the setup of SQL Server SP2 or a later version, you receive the following error message:

Setup has detected one or more databases and filegroups which are not writable. Refer to sp2readme.htm for more information. Setup will continue.

Then, you can continue the setup of the service pack. If you choose to continue, the Setup program stops responding later (as explained in the &quot;Symptoms&quot; section). However, in the Setup program for SQL Server SP1, you cannot continue the Setup program (nor are you given the option to continue).

