Systems Engineering and RDBMS

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:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall

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.

One Response to “WSS 3.0 and SQL Server Embedded Edition”

  1. […] Connecting to WSS 3.0 SP2 database instence Microsoft Sql Server Embedded Edition Microsoft##SSEEWSS 3.0 and SQL Server Embedded Edition […]

Sorry, the comment form is closed at this time.

 
%d bloggers like this: