locked
How to uninstall SQL Express 2005 (Really!) RRS feed

  • Question

  •  

    I installed SQL Server Express 2005.  It could not finish the install correct because it said I was not an administrator. However I am an administrator.  I had the brilliant idea of uninstalling and using mixed authentication so I would have an sa account to get into SQL Server Express 2005.  It took me several tries to get SQL Server Express 2005 to uninstall. Initially It would not uninstall probably because there was some file in use. After a couple of reboots it did finally appear to uninstall.  When I tried to reinstall, I was told by the install program that there was already an instance of SQL Server 2005 Express with the same name so I would have to use a different name.  However there was no facility displayed to change the name. There was a facility to set the name on the initial install.

     

    I really don't want to have to format the drive to get rid of SQL Server 2005 Express.

     

    Any suggestions?

     

    Thanks

    David Coulter

    Saturday, November 8, 2008 4:06 PM

Answers

All replies

  • hi David,

    try having a look at this article about "manually uninstalling SQL Server"..

    regards

    Saturday, November 8, 2008 5:09 PM
  • I am replying to myself. I found an article http://support.microlsof.com/kb/909967.  Following these instructions worked.  I was able to successfully install SQL Server Express 2005. Hope this helps someone.

    Saturday, November 8, 2008 5:18 PM
  • Thanks!!  I just found it and followed it with great success.

     

    Saturday, November 8, 2008 5:19 PM
  • Hello,

     

    Please, could you provide more informations ?

    - Edition of your Sql Server Express 2005 ( "basic",with tools,with advanced services ) with reporting...

    - OS of your workstation : Edition and version ( XP Pro or Home,Vista Pro,Home or Windows Server 2003/2008 ) and SP level

     

    In fact, as the install has failed, you have had several keys of the registry which are updated only after a reboot ( it is why it is always better to do supplementary reboots sometimes as it is during the reboot that the install or uninstall is finished)

     

    Moreover, as soon as the install is nearly finished, the services related to Sql Server ( SqlBrowser,SqlServerService,ReportingServices... ) are started  and they are using files. If you stop all these services, you should have had no problems.

     

    We are waiting for your feedback to try to help you more efficiently

     

    Have a nice day

    Saturday, November 8, 2008 5:28 PM
  • Hello David,

     

    Your link http://support.microlsof.com/kb/909967 seems broken for me

     

    Have a nice day

     

    Saturday, November 8, 2008 5:32 PM
  • hi Papy,

    yep, some typos in David's link.. try http://support.microsoft.com/kb/909967/en-us

    regards

    Saturday, November 8, 2008 7:15 PM