Delete damaged instance - SQL server 2000

Posted on 2008-09-29
Medium Priority
Last Modified: 2012-05-05
Running SQL server 2000 Enterprise on HP ML150 server.
Installed one instance successfully.  The other instance (TESTSQL) failed to install correctly.  Event viewer said cd had a bad block.  Cannot uninstall TESTSQL. Message says log file is corrupt, uninstall will cease.  

I have tried to reinstall TESTSQL, machine tells me an instance with that name already exists.  I need that instance.  How do I fix this?

Urgent problem - 500 points
Question by:donpick
1 Comment
LVL 14

Accepted Solution

Jagdish Devaku earned 2000 total points
ID: 22602895

You can do it by following the below steps:

Remove a specific instance of SQL Server
To remove a specific instance of SQL Server, follow these steps: 1. Locate, and then delete the %drive%:\Program Files\Microsoft SQL Server\MSSQL\Binn folder where %drive% is the location of the instance of SQL Server you want to remove.
2. Locate, the following registry key: " HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

Note If you are deleting a default instance, you must delete all the keys EXCEPT the Client key.
" HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

You must use Regedt32.exe to edit the InstalledInstances value of the instance you are removing. A default instance is listed as MSSQLSERVER, and named instances appear as the name given to the instance.

Note You cannot use Regedit.exe to edit the value; you must use Regedt32.exe instead.
For more info, check the below link:


All the best... let me know if you are facing any issues...

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question