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.
- See also this post at the MSDN forums.