SharePoint Connect to DB

I am using the lite sharepoint version 2008 and the trickiest thing for me was figuring out how to connect to the database.  Figured out that Windows Sharepoint Services (WSS) 3.0 ship with SQL Server 2005 Embedded Edition. Now called the Windows Internal Database.

Steps for connecting to the internal SSEE database:

  • Open us Microsoft SQL Server Management Studio 2008
  • Server Name:   \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
  • Use Windows Authentication

 

More information can be found here.

Leave a Reply

Your email address will not be published. Required fields are marked *