Use SQL Server Management Studio Express with SQL Server Embedded Edition

  • Article

Ever installed a WSS stand-alone machine? Well in this case, all your databases will be hosted by a SQL Server Embedded Edition instance. And then you may ask yourself, how you could connect to that instance? Here are the steps you need to perform:

- download and install SQL Server 2005 Management Studio Express (from here)
- connect to the instance using the following server name:

 \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Hope this helps ...