TF246021: An error occurred while processing your request. Technical information (for administrator): SQL Server Error: 18054

Question

Recently, I downloaded the Visual Studio 2010 RTM(expires on April 9, 2012) and moved our source code, created a new build definition.

 

However, every build fails when it tries to check-in the "AssemblyInfo.vb" file into TFS at the step below.

-----------------------

Checkin
Initial Property Values
Workspace = 3_1_WIN-GS9GMUJITS8;NT AUTHORITY\SYSTEM
Final Property Values
Workspace = 3_1_WIN-GS9GMUJITS8;NT AUTHORITY\SYSTEM

TF246021: An error occurred while processing your request. Technical information (for administrator): SQL Server Error: 18054

-----------------------

The User NT AUTHORITY\SYSTEM has the file locked for check-in. I un-did the action, deleted the workspace but the problem re-appears.

Appreciate any pointers.

Answer 1

After considerable effort, decided to create the projects under a 'NEW' collection rather than using the existing collection that came with the Visual Studio 2010 RTM and now all my builds are working!

Answer 2

How can renaming the collection be a valid answer? Say we get this error message after TFS Server in operation for one year we cannot just rename the collection or project for that matter. We are getting the same error any recommendations to resolve it?