Connect to SharePoint database on MICROSOFT##SSEE

This handles the annoyance when trying to connect to the embedded SQL Server that SharePoint uses by default for its config and content. When you attempt to connect with SQL Server Management Studio (SSMS) you’ll receive a connection error if you try the age old SERVER/INSTANCE model.

Instead, to connect to the MICROSOFT##SSEE database instance:

Use “\\.\pipe\mssql$microsoft##ssee\sql\query” as your Server name in SQL server management Studio.

About the Author