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
use windows authentication
“.” 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
but thats only for the fully paid version which I don’t have as I don’t need the features at the moment.