SharePoint 2010: Configure SQL Management Studio Express to Talk to Default Sharepoint Instance

SharePoint 2010: Configure SQL Management Studio Express to Talk to Default Sharepoint Instance

Download

Configure

Configure the built-in SQL instance for remote management by SQL Server Management Studio Express

  1. Open the "SQL server Configuration Manager"
  2. Right-click the line "Protocols for MICROSOFT##SSEE" and choose "Properties"
  3. Set "hide instance" field is set to "no" instead
  4. Under protocols, enable TCP/IP and Named Pipes
  5. Restart the microsoft##ssee service

I found the above steps here.

Access the SQL instance using SQL Server Management Studio Express

  1. Start SQL Server Management Studio Express
  2. Connect to this instance: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
  3. You may need to check Windows Authentication

I found the instance name here. Now that you have access to the instance you may perform regular tasks to it, such as backing it up, detaching it and so on: Original Content

Leave a Comment
  • Please add 3 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Richard Mueller edited Revision 5. Comment: Change tag "SQL Server 2008R2" to "SQL Server 2008 R2"

  • Richard Mueller edited Revision 3. Comment: Remove (en-US) from title

  • Craig Lussier edited Revision 2. Comment: added en-US to tags and title

  • Jeffrey S. Patton edited Revision 1. Comment: I should really go through and update the things I posted with the new URLs

Page 1 of 1 (4 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Jeffrey S. Patton edited Revision 1. Comment: I should really go through and update the things I posted with the new URLs

  • Craig Lussier edited Revision 2. Comment: added en-US to tags and title

  • Richard Mueller edited Revision 3. Comment: Remove (en-US) from title

  • Richard Mueller edited Revision 5. Comment: Change tag "SQL Server 2008R2" to "SQL Server 2008 R2"

Page 1 of 1 (4 items)