Sharepoint database connection string – what is it?

I use Team Foundation Server (TFS) for source control of my current data warehouse project with SSIS, SSRS and SSAS but my requirements documents which are mostly word but also Excel, Visio and xMind (Excellent mind mapping diagram software) were simply held on a file share. To get these into TFS requires Windows Sharepoint Server which I had not yet installed. Mapping the Sharepoint to the TFS is a nightmare though with terrible supporting documentation which I will cover this in another post. Anyway, I digress: As part of the process though I wanted to view the Sharepoint Services database in SSMS and could not remeber how to do this and had to look it up which is annoying as I have done this before so I thought I would write a simple post here mainly for my own future reference of what the ridiculous connection string looks like

Windows Sharepoint Services version 3.0 is the free version that you can plug in to TFS to manage document version control.

Here’s how you can connect to the database…

Open Management studio on the server (not a remote connection)
Put this in the server name
\\.\pipe\mssql$microsoft##ssee\sql\query
use windows authentication

Note:
“.” is the name of the server and means local machine
Windows Authentication must be used as this sql server is owned and created by the Sharepoint Installation
SQL Authenticated cannot be used. You can make one but you still cannot use it on this type of database so there isnt much point.
You must be on the local machine too as remote connections cannot be enabled on this type of SQL Server database
(I bet you can hack both of these restricts by enabling editing of the system catalogs and changing a few settings – never tried it so don’t blame me if you break it)

This connection string also works for the 2007 Sharepoint databases

and before you post a comment on this – I know this is not a connection string really – its the string that you put in the server name but you can’t really call it a server name can you? (its a bit weird for that, which is why its forgettable)

For 2010 its a simpler affair with just
.\sharepoint
but thats only for the fully paid version which I don’t have as I don’t need the features at the moment.

Advertisements

About davidbridge

I am a contractor for David Bridge Technology Limited specialising in database design and Web development using Microsoft technologies such as c#, MVC .net and SQL Server (full stack)
This entry was posted in Developer stuff, SQL Stuff and tagged , , , , , . Bookmark the permalink.

5 Responses to Sharepoint database connection string – what is it?

  1. Pingback: Sharepoint database connection string – SQL Server Development … | ARB Security Solutions

  2. Eric Burns says:

    The skills of a SharePoint expert are vital if you want to achieve success in making use of SharePoint as your business model. The knowledgeable aids you create applications and solutions that are excellent for your enterprise.

  3. Excellent write-up, I will be typical website visitor of the blog, maintain inside the excellent function, and it’s really gonna be an everyday website visitor to get a prolonged time.

  4. Just wish to say your article is as astonishing.

    The clearness on your publish is just spectacular and that i can assume you’re an expert in this subject. Well along with your permission let me to seize your feed to keep up to date with forthcoming post. Thanks one million and please keep up the enjoyable work.

  5. This is a topic which iss close to my heart… Cheers! Exactly where are your
    contact details though?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s