We're running TFS on two nodes IIS from box 1 and the data server on box 2, both machines are running Windows 2003 64 bit, with SP1, the database is SQL Server 2005 64bit with SP2.
We have applied TFS SP1 successfully six weeks ago, but get the following errors in the database errorlog intermittently;
2007-06-06 14:59:46.01 spid68 Error: 18054, Severity: 16, State: 1.
2007-06-06 14:59:46.01 spid68 Error 500119, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.
Is this a SP1 induced bug ? I have given TFSERVICE sysadmin rights on the data server so it's not a privilege issue.