You receive a "The handle is invalid" error message when you install SQL Server 2000 SP2, SQL Server 2000 SP3, or SQL Server 2000 SP4 on Virtual SQL Server (811882)


The information in this article applies to:

  • Microsoft SQL Server 2000 Enterprise Edition SP2
  • Microsoft SQL Server 2000 (all editions) SP3
  • Microsoft SQL Server 2000 (all editions) SP4

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:
  1. Use the Cluster Administrator utility to switch all the SQL Server cluster group resources offline.
  2. 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.
  3. 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:
    1. 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.
    2. Use the Cluster Administrator to modify the dependencies of other resources from the SQL Network Name resource to the Temp Network Name resource.
  4. 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.
  5. 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.
  6. Bring all the SQL Server cluster group resources back online.
  7. 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

Modification Type:MinorLast Reviewed:3/15/2006
Keywords:kbtshoot kbUpgrade kbSysAdmin kbClustering kbprb kberrmsg KB811882 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.