How to connect SQL Embedded Edition using SQL Management Studio

If you have installed WSS 3.0 with Embedded SQL edition and you wanted to get connected to the instances with MS SQL Managemen Studio for manageing the DB, Please follow the below steps to reach there.

Here is how we connect to the Embedded SQL instance:

We can create a Server Alias for the "MICROSOFT##SSEE" named instance.

1. Run "cliconfg" on the box from the command line or from Start --> Run

2. In the "SQL Server Client Network Utility" console, click the Alias tab.

3. Create a new Server alias.

4. Server alias: \MICROSOFT##SSEE

5. Replace with the exact server.
Network libraries: Named Pipes
Server name: .\MICROSOFT##SSEE
Pipe name: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

6. Then open SQL 2005 management studio, input \MICROSOFT##SSEE as Server Name.

Now you can use SQL 2005 management studio to connect to the SQL data for SharePoint site successfully.

Hope above information is helpful

Cheers !!