Skip to main content

TFS Work Hub no longer works after installing Security Update for SQL Server 2016 SP2 CU(KB4293807)

UPDATE: This is indeed an issue confirmed by Microsoft: https://blogs.msdn.microsoft.com/sqlreleaseservices/issue-with-security-update-for-the-remote-code-execution-vulnerability-in-sql-server-2016-sp2-cu-august-14-2018/. Thanks Michael for sending me the link.

After installing the security update below on our TFS database tier, we could no longer connect to the Work hub in TFS(other features still seemed to work).
image
The error we got on the work page was:
TF246017 Team Foundation Server Could Not Connect to the Database.Verify that the server that is hosting database is operational,and that network problem are not blocking communication with server.
In the windows event logs, we found the following information:
A user request from the session with SPID 61 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
I couldn’t find a (better) solution, so we decided to rollback this security update.