Monday, December 18, 2006

Uninstall SQL Server 2005 Embedded Edition

Last week when I was testing the Windows Sharepoint Services v3 (WSS3) I found this is a pretty bad practice provided by Microsoft. When uninstall WSS3 it did not uninstall the SSEE from my Server (they may have some good reason behind this). After searching the web found a solutions on this site.

Uninstall SQL 2005 Embedded Edition SSEE

For ease of reference I add the content below;

  • Start Registry Editor, and then locate the following registry key:
    HKEY_LOCAL_MACHINE\
    SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall

  • In the left pane, click each GUID. For each GUID that you click, look for a display name in the right pane that matches “Microsoft SQL 2005 embedded Edition…”. When you see a display name that matches the name, copy the value of the Key named “UninstallString”

  • Open a Command-Window (Start->run->cmd)

  • Paste the Copied string.

  • Append "CALLERID=OCSETUP.EXE" eg.
    "MsiExec.exe /X{BDD79957-5801-4A2D-B09E-852E7FA64D01} CALLERID=OCSETUP.EXE"

    Alternatively you may want to create a batch file for this, this is because you can't paste the string into DOS prompt. ;)

  • There you go Don’t forget to reboot.




      No comments: