Article ID: 811882
Article Last Modified on 3/15/2006
APPLIES TO
- Microsoft SQL Server 2000 Service Pack 2
- Microsoft SQL Server 2000 Service Pack 3
- Microsoft SQL Server 2000 Service Pack 4
SYMPTOMS
When you install Microsoft SQL Server 2000 Service Pack 2 (SP2), SQL Server 2000 Service Pack 3 (SP3), or SQL Server 2000 Service Pack 4 (SP4) on Virtual SQL Server, the installation might fail and you receive the following error message:
The SQL Server 2000 setup log file, Sqlstp.log, will contain the following information:
12:07:33 Begin Setup 12:07:33 Version on Media: 8.00.534 12:07:33 Mode = Normal 12:07:33 ModeType = NORMAL 12:07:34 Begin: SetupInitialize() 12:07:34 End: SetupInitialize() 12:07:34 Begin: CheckFixedRequirements() 12:07:34 Platform ID: 0xf00000 12:07:34 Version: 5.0.2195 12:07:34 File Version - C:\WINNT\System32\shdocvw.dll: 5.0.3315.2879 12:07:34 End: CheckFixedRequirements() 12:07:34 Processor Architecture: x86 (Pentium) 12:07:34 Service Pack: 512 12:07:34 ComputerName: DBNODE1 12:07:34 User Name: user_name 12:07:34 IsAllAccessAllowed returned: 1 12:07:34 OS Language: 0x409 12:07:34 Begin: SetupInstall() 12:07:34 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ... 12:07:34 CommonFilesDir=C:\Program Files\Common Files 12:07:34 Windows Directory=C:\WINNT 12:07:34 Program Files=C:\Program Files 12:07:34 TEMPDIR=C:\DOCUME~1\admin~1\LOCALS~1\Temp\1 12:07:34 End: SetupInstall() 12:07:36 Begin: ShowDialogs() 12:07:36 Initial Dialog Mask: 0x8300037, Disable Back=0x1 12:07:36 Begin Action ShowDialogsHlpr: 0x1 12:07:36 Begin Action: DialogShowSdWelcome 12:07:40 End Action DialogShowSdWelcome 12:07:40 Dialog 0x1 returned: 1 12:07:40 End Action ShowDialogsHlpr 12:07:40 ShowDialogsGetDialog returned: nCurrent=0x2,index=1 12:07:40 Begin Action ShowDialogsHlpr: 0x2 12:07:40 Begin Action: DialogShowSdMachineName 12:28:35 ShowDlgMachine returned: -1 12:28:35 ShowDlgMachine: GetLastError returned: 1223 12:28:35 The operation was canceled by the user. 12:28:35 End Action DialogShowSdMachineName 12:28:35 End: ShowDialogs() 12:28:35 Action CleanUpInstall: 12:28:35 Installation Failed.
CAUSE
After you type the virtual server name in the text box of the SQL Server installation wizard, and then click Next, the setup program checks for the validity of the virtual server name by checking the resource type for SQL Server, depending on the Network Name ( SQL Network Name) resource. If the setup program does not find the SQL Server resource as the first resource that depends on the SQL Network Name resource, the setup may fail.
RESOLUTION
To resolve the problem, use these steps:
- Use the Cluster Administrator utility to switch all the SQL Server cluster group resources offline.
- Check the dependencies of each resource in the SQL Server cluster group. If a resource that has SQL Network Name is listed as one of the dependencies, remove SQL Network Name from the dependencies list.
- For any other resource, such as an MSDTC resource that requires a Network Name resource as one of it dependencies, use these steps to remove the dependency:
- Create a new Network Name resource and name it Temp. Make it dependent on the SQL IP address resource. Leave the Temp resource in offline state.
- Use the Cluster Administrator to modify the dependencies of other resources from the SQL Network Name resource to the Temp Network Name resource.
- For the SQL Server resource, add the SQL Network Name resource to the dependencies list of the SQL Server resource. Verify that the SQL Server resource is the first clustered resource that has a dependency on the SQL Network Name resource.
- For other resources that depend on the SQL Network Name resource, remove the Temp Network Name resource and add SQL Network Name to the dependency list.
- Bring all the SQL Server cluster group resources back online.
- Run the setup again
REFERENCES
For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
243218 Installation order for SQL Server 2000 Enterprise Edition on Microsoft Cluster Server
307336 How to change a clustered SQL Server Network Name
Additional query words: MSCS
Keywords: kbtshoot kbupgrade kbsysadmin kbclustering kbprb kberrmsg KB811882