Well this came in handy the other day…
Use this path, to connect to your local SharePoint Windows Internal Database (WIB) using SQL Server Management Studio Express (2005).
.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
(note: there are two backslashes at the front of that syntax that aren’t shown via HTML, so don’t forget those)

Leave a comment