Use SQL Server Management Studio Express with SQL Server Embedded Edition
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 ...