remove named instance

[djj55]

Hello,
For SQL Server 2000 I would like to remove a named instance.
The test SQL server was moved to another windows server and we now would like to cleanup the original server.

Reading KB 290991 it says I need to reinstall SQL Server (step 3).

Remove a named instance of SQL Server
To remove a named instance of SQL Server, follow these steps:
1. Locate, and then delete these registry keys for a Named Instance, where InstanceName is the name of the instance that you are removing.
• HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer$InstanceName
• HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT$InstanceName
2. If the instance of SQL Server you are removing was clustered, remove any cluster resources for this instance of SQL Server that may remain in the Cluster Administrator.

Note Only remove SQL Server resources.
3. Reinstall Microsoft SQL Server 2000 and use the same name, and IP address.
4. Run the Setup for the installation, and then use the Uninstall option to clean up any configuration problems or errors that may still exist because of the failed installation.

What server name and IP address are they talking about? Steps 3 and 4 are confusing to me.

Thank you,
djj

 

[mrdenny]

Those are the instructions for removing SQL Server from a cluster.

To uninstall from a non-clustered machine you should simply need to run the uninstaller from Add/Remove Programs.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog