Scenario
I’m working on a WSS 3.0 box and it’s completely out of disk space due to the database logs being full in the SharePoint_AdminContent database. For some reason, the genius who installed SharePoint on this box (which is hosting a client’s training registration portal) didn’t bother installing SQL Server or doing anything the right way. Hooray for SharePoint n00bs!
To fix the problem, I opened SQL Server Management Studio and attempted to connect to SERVERNAME\MICROSOFT##SSEE. It failed to connect. Ok, now what?
Solution
After a quick “binging” of the web, I found this link, on which Mitch H commented the following:
Begin quote
...or put
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
as the server name.
End quote
In SQL Server Management Studio’s “Connect to Server” dialog, I entered just that in the “Server name” drop-down list and connected without a problem. Now if only truncating the log would have solved my problems…