Can’t connect to MICROSOFT##SSEE DB

I had a Windows Small Business Server 2008 with WSS 3.0 running on it.  I needed to get to the content databases. I tried to connect to the SQL instance using the default server name (SERVER)\MICROSOFT##SSEE in SQL Management Studio. I was unable to connect no matter what account I used. I discovered it is installed on a windows internal database. Even though the server had SQL Express edition installed I still could not connect via the default server name. I found out that you have to connect using the named pipe. Here is what should be used to connect through SQL Management studio:

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

Leave a reply