Microsoft KB Archive/811882

= You receive a &quot;The handle is invalid&quot; error message when you install SQL Server 2000 SP2, SQL Server 2000 SP3, or SQL Server 2000 SP4 on Virtual SQL Server =

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 handle is invalid.

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. </li> 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.</li> 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.</li> Bring all the SQL Server cluster group resources back online.</li> Run the setup again</li></ol>

<div class="references_section">