Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I installed MS SQL Server 2008 R2 and I named my default instance "MSSQLSERVER". I want to uninstall that instance and start over. I used the Programs and Features control panel to completely remove MS SQL Server but when I run the installer again, the "MSSQLSERVER" instance remains. I know I can just create a new instance and call it something else but it bugs me that I didn't completely remove it.

I have searched the MS KB for information on removing MS SQL Server and everything I've found so far indicates that all I have to do is to use the Programs and Features control panel.

Can someone explain to me how to remove this instance or, if it's not possible, why not?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Looks like a failed uninstall. Try the following command line option to manually uninstall the instance:

At a command prompt, type the following command, and then press ENTER:

CD %ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\Release

Type the following command, and then press ENTER:

setup.exe /ACTION=uninstall /FEATURES=SQL /INSTANCENAME=MSSQLSERVER

Reference http://support.microsoft.com/kb/955404

If this doesn't work, let me know; there are some other ways we can try...

share|improve this answer
    
Thanks for the help. –  ericso Jan 12 '12 at 0:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.