Things to do with Embedded Edition of SQL Server 2005

Embedded edition of SQL Server that comes part of Microsoft Windows SharePoint Service 3.0 basic installation is left with less documentation. This edition of SQL Server is also called as Windows Internal Database. Here are few things you may like to do with it.

Locating the service instance

Open services management console (services.msc), you should find a instance with name Microsoft##SSEE

Connecting from SQL Server Management Studio

Open management studio (With admin elevated mode in Windows Vista)

Server Name - "\\.\pipe\mssql$microsoft##ssee\sql\query"

Uninstalling

It is perfectly hard to figure out what it takes to completely uninstall the Embedded Edition of SQL Server, of course you can stop and disable the service.

Following steps would help you remove the service completely.

  1. Start -> Run
  2. msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe
  3. OK

 

del.icio.us Tags: SQL Server,SharePoint