Manual UnInstall for SQL Server 2008 R2 standard edition

  • ALIF-662928


    Points: 6054


    I have installed sql server 2008 R2 standard edition twice, default and another named, both of the installations failed to install sql server, but the thing is they are capturing the registry as if they are installed, taking the default instance spot with the services shown in the configuration manager,

    I have tried to uninstall it from control panel, programs and feautures, but its not removing that feature from it,

    Can someone please tell me the steps to remove it manually from the registry so that i can be able to install default instance once again.


  • george sibbald

    SSC Guru

    Points: 104200

    Is uninstall\reinstall of the OS an option for you?


  • SQL DBA-909494


    Points: 1605

    After uninstalling with the uninstall option, just delete all the SQl folders from the drives & then go to the registry -->HKEY_Localmachine & delete any entries related to SQL server in the Microsoft folder. Also grant full permission to the microsoft folder in registry before you reinstall.

    **"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **

  • dan-572483


    Points: 15865

    You should also go into Local Users and Groups\Groups and delete the SQLServer* groups that the install creates. These can also cause new problems when re-installing after a failed install.

  • SQLKnowItAll

    SSC Guru

    Points: 61781

    Just saw this link in another post from Lowell:

    PFE - Microsoft
    SQL Know-It-All
    How to post data/code on a forum to get the best help - Jeff Moden[/url]

  • Lowell

    SSC Guru

    Points: 323450

    SQLKnowItAll (5/22/2012)

    Just saw this link in another post from Lowell:

    I was going to paste it here two! two questions on the same subject just a couple of minutes apart; small world.


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • george sibbald

    SSC Guru

    Points: 104200

    Am I missing something here? That link describes itself as how to manually remove SQL but then goes on to describe how to do it via control panel which is the normal method, and is not working for the OP. There is nothing in there about delving into the registry.

    It would be interesting to know how the OP actually resolves this.


  • MudLuck


    Points: 2301

    What a contribution. What a link! What's next?

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply