The Power Tools are always a must-have download. Although they are ‘officially unspported’ they give you funcionality upfront that is probably going to be in the next version of Visual Studio.
New and added features include:
- Team Foundation Server Power Tool Commands (tfpt.exe) – A command-line tool with enhanced functionality for Team Foundation Version Control with graphical user interfaces for some commands.
- Process Template Editor – A tool integrated with Visual Studio for authoring custom work item types and some of the associated process template components.
- Check-In Policy Pack – A set of handy check-in policies to address needs customers have expressed. These include Custom Path Policy, Forbidden Patterns Policy, Changeset Comments Policy, and Work Item Query Policy.
- Test Tools Build Task – A tool that allows running unit tests by simply specifying the DLLs, or by specifying a file name pattern in TfsBuild.proj, instead of using .vsmdi files to specify tests to run.
Read more here.
It’s a horor scenario you probably don’t really like to think of: You install Service Pack 1 on your production Team Foundation Server and from that moment on all connections (even from the server machine) result in one of the errors stated in the title of this post… if this is the cast: this is probably not your day!
The good news:
- You are not alone!
- There is help (a workaround)!
- Change the directory security in ISS from “deny access” to “granted access”.
- Change the TFS SQL server databases (TfsActivityLogging, TfsBuild, TfsIntegration, and TfsVersionControl) from SINGLE_USER to MULTI_MODE.
- Restart IIS – and you should be fine.
Use at your own risk! Although it worked for me, it doesn’t neccessarily work for you as well!
The Quiescence patch for TFS changed IIS’s directory security to “deny access” and the switched the databases from MULTI_MODE to SINGLE_USER that no data corruption occures during the update process. For some reason this is in some cases not reverted automatically. Microsoft is investigating the issue and preparing to create a fix.