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).
.pipeMSSQL$MICROSOFT##SSEEsqlquery
(note: there are two backslashes at the front of that syntax that aren’t shown via HTML, so don’t forget those)