We help IT Professionals succeed at work.

delete SQL Server instance in SQL server 2005

yrcdba7 asked
I have installed sql server 2005 with default instance, one of name instance I want to delete it. How to do it.


Watch Question

Go to Add\Remove programs and select SQL 2005 Server you will then get the option to remove a solitary instance.



I couldn't see that SQL server 2005 with name instance there. I have SQL server 2005 default instance which I can see in add\remove and I want to keep this but I want to delete sql server 2005 name instance which I could't see in add\remove but I can see it in SQL server 2005 configuration area.

My default instance is MSSQLSERVER
the name instance is TESTSRV\nameinstance

I want to delete TESTSRV\nameinstance, but I can not see it in add\remove. I can see it in register.

Note from MSDN guide.

Remove all known instances of SQL Server
To remove all known instances of SQL Server, follow these steps:

   1. Locate, and then delete the %drive%:\Program Files\Microsoft SQL Server\MSSQL\Binn folder.
   2. Locate, and then delete these registry keys:
          * HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

   3. Locate, and then delete these registry keys:
          * HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
          * HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper
   4. The three registry keys in step 3 correspond to the default instance of Microsoft SQL Server 2000. Named instances appear similar to those listed in step 3, along with $instance_name, because instance_name is the name given to your particular instance. After you locate the correct keys for the instance you are removing, select those keys, and then delete them.
          * HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer$InstanceName
          * HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT$InstanceName
          * HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper

   5. If the instance of SQL Server you are removing was clustered, remove any cluster resources for the instance that may remain in the Cluster Administrator.

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