Error while installing the SQL Server 2000 Virtual Instance

When you try to install an instance of Microsoft SQL Server 2000 virtual server on the failover cluster nodes that are running Microsoft Windows Server 2003, you may notice that the SQL Server 2000 virtual server installation is not completed successfully. Additionally, you may receive the following error message:

“An error occurred while creating virtual server resources for clustering. Cluster specific registry entries couldn’t be written”.

This error occurs when the SQL Server 2000 virtual server Setup program tries to create the virtual server resources on the remote nodes in the failover cluster.

Resolution

You must make sure that the Winreg subkey is configured with the correct permissions on all the nodes that are participating in the failover cluster. To do this, follow these steps on each node that is participating in the failover cluster:

Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

1. Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, right-click the following registry subkey, and then click Permissions: HKEY_LOCAL_MACHINE\SYSTEM\CurentControlSet\Control\SecurePipeServers\Winreg
3. Make sure that the following Windows user groups and the Windows user accounts on the node appear in the Group or user names list and have these permissions:
   • Administrators group: Full Control and Read permissions
   • Backup Operators group: Read permission
   • LOCAL SERVICE account: Read permission
4. Close Registry Editor.

Related Posts

1. SQL Server Cluster Resource Failed When Bringing Online
2. Cannot install SQL Server cluster on a computer that runs Microsoft Windows Server 2003
3. SQL Server 2000 Maintenance Jobs Failed with Error 22029
4. Troubleshooting SSRS Error “The report server is not responding”
5. Consistency Errors in MS SQL Server 2000

Tags: sql server 2000, SQL Server Installaion Error, SQL Server Virtual Installaion, windows server 2003