SQL SERVER 2000 INSTALLATION/UNINSTALLATION ISSUES ON STANDALONE/CLUSTERED ENVIRONMENT

Consider a scenario where on an Active Passive Cluster, while uninstalling an instance of sql2000 patched with Service Pack 4, we see the following error after you click next on the screen where we enter the Virtual Server name.

'The specified virtual server cannot be maintained by this version of setup'.

We are not able to proceed further because of the above error.

EXPLANATION(Resolution in one of my case)

=========================================

The registry key value for HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion\CurrentVersion was set to 8.00.201. This value can be anything but not 8.00.194.

This key value should be 8.00.194 ,even when a service pack has been applied on Sql Server as in our case.

We changed the value of the CurrentVersion key to 8.00.194

After changing the value as mentioned above, the Uninstallation went fine.

Additional Information:

-----------------------------

We have seen cases, where while trying to upgrade from SQL Server 2000 standalone instance to a SQL Server 2000 clustered instance, In the Installation Selection page of the setup the "Upgrade, remove, or add components to an existing instance of SQL Server" option was grayed out

The above fixed this issue as well.

IMPORTANT : This resolution contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

Pradipta Das
SE, Microsoft Sql Server

Reviewed By

Mukesh Nanda
Technical Lead, Microsoft Sql Server