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)!
The 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.
The Disclaimer:
Use at your own risk! Although it worked for me, it doesn’t neccessarily work for you as well!
The Background:
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.
Other Threads
- See also this post at the MSDN forums.
Good luck!
That warm tingly feeling is me sending you the deepest thanks I can. This has been killing me for several DAYS now. Thanks for posting!
You’re welcome!
Neno
Thank you!! this help me to work out this issue