You are currently offline, waiting for your internet to reconnect

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

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 Setup12:07:33 Version on Media: 8.00.53412:07:33 Mode = Normal12:07:33 ModeType = NORMAL12:07:34 Begin: SetupInitialize() 12:07:34 End: SetupInitialize()12:07:34 Begin:  CheckFixedRequirements()12:07:34 Platform ID: 0xf0000012:07:34 Version: 5.0.219512:07:34 File Version - C:\WINNT\System32\shdocvw.dll: 5.0.3315.287912:07:34 End:  CheckFixedRequirements()12:07:34 Processor Architecture: x86 (Pentium)12:07:34 Service Pack:  51212:07:34 ComputerName: DBNODE112:07:34 User Name: user_name12:07:34 IsAllAccessAllowed returned: 112:07:34 OS Language: 0x40912:07:34 Begin:  SetupInstall()12:07:34 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...12:07:34 CommonFilesDir=C:\Program Files\Common Files12:07:34 Windows Directory=C:\WINNT12:07:34 Program Files=C:\Program Files12:07:34 TEMPDIR=C:\DOCUME~1\admin~1\LOCALS~1\Temp\112:07:34 End:  SetupInstall()12:07:36 Begin:  ShowDialogs()12:07:36 Initial Dialog Mask: 0x8300037, Disable Back=0x112:07:36 Begin Action ShowDialogsHlpr: 0x112:07:36 Begin Action:  DialogShowSdWelcome12:07:40 End Action  DialogShowSdWelcome12:07:40 Dialog 0x1 returned: 112:07:40 End Action ShowDialogsHlpr12:07:40 ShowDialogsGetDialog returned: nCurrent=0x2,index=112:07:40 Begin Action ShowDialogsHlpr: 0x212:07:40 Begin Action:  DialogShowSdMachineName12:28:35 ShowDlgMachine returned: -112:28:35 ShowDlgMachine: GetLastError returned: 122312:28:35 The operation was canceled by the user.12:28:35 End Action  DialogShowSdMachineName12: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
MSCS
Properties

Article ID: 811882 - Last Review: 03/15/2006 00:07:58 - Revision: 4.3

  • Microsoft SQL Server 2000 Service Pack 2
  • Microsoft SQL Server 2000 Service Pack 3
  • Microsoft SQL Server 2000 Service Pack 4
  • kbtshoot kbupgrade kbsysadmin kbclustering kbprb kberrmsg KB811882
Feedback