Systems Engineering and RDBMS

  • Click Here for Decipher's Homepage

  • Categories

  • Questions?

    Please send your wish list of things that you would like us to write about or if you have suggestions to help improve this blog site. You can send all questions/suggestions to: Blog Support
  • Archives

  • Blog Stats


Archive for May 6th, 2007

WSS 3.0 and SQL Server Embedded Edition

Posted by decipherinfosys on May 6, 2007

If you have installed WSS 3.0 in a standalone configuration, the install also sets up an instance for SQL Server Embedded Edition. This is the instance where it creates it’s content management and search databases. However, when you un-install WSS 3.0 from the system, it does not automatically remove this instance. Here is how you can remove that instance manually:

1) Using regedit, locate this registry key:


2) Search under this for “Embedded”. In the left side, click the GUID that it found via the search. Then, copy the value under the key named: “UninstallString”.

3) Go to the command prompt and then paste the copied string. Now, write this up after that text : ” CALLERID=OCSETUP.EXE”. Press Enter.

4) This will ask for confirmation to remove this installation.

Once the un-install has been done, please do remember to re-boot for the changes to take place. However, even after you do this, though this takes care of removing the services, it still leaves the database files in the %windir%\SYSMSI\SSEE folder. Search for those mdf/ldf files and you can delete them manually.

This is also covered under a MSFT technet post. After opening up the link, search for: “Uninstalling WSUS 3.0 does not uninstall the database instance”.

If you want WSS to use some other Edition of SQL Server, you have to install it in the web farm mode and not in the standalone mode. Then, you will get the option of choosing a different SQL Server Edition Instance when you are configuring WSS 3.0.

Posted in Sharepoint | 1 Comment »