Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (8Microsoft Partne)
  • When: 22 Sep 2010 7:34 PM
  • Last revision by (cMVP, Microsoft Community Contributo)
  • When: 18 Sep 2013 7:20 PM
  • Revisions: 7
  • Comments: 4
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  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

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

, , , , , [Edit tags]
Leave a Comment
  • Please add 5 and 7 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 18 Sep 2013 7:20 PM

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

  • 14 Aug 2013 8:06 PM

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

  • 18 Feb 2012 11:42 AM

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

  • 3 Mar 2011 7:50 AM

    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
  • Posted by
    on 3 Mar 2011 7:50 AM

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

  • Posted by
    on 18 Feb 2012 11:42 AM

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

  • Posted by
    on 14 Aug 2013 8:06 PM

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

  • Posted by
    on 18 Sep 2013 7:20 PM

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

Page 1 of 1 (4 items)