The issue linking my DB to TFS seems to be that SSMS for 2008R2 SP1 is choking when it tries to connect to TFS. Its giving me an error
TF400324: Team Foundation services are not available from the server
Unable to connect to the remote server.
I have edited the config file as instructed though the instructions are frankly a bit rubbish. Seriously, read that page and see how much sense it makes.
Look at Andy Leonards blog post about it
http://sqlblog.com/blogs/andy_leonard/a ... eview.aspx
This is much clearer about what the config file should look like once you're done.
The URL I am using is identical to the one that is working in Visual Studio team Explorer.
Actually I just tried something stupid. I removed the port number from the URL and it now seems to be working.
I am such an idiot!