A database error (SQL Server 18054 error) occurred while mapping the local directory to TFS

Question

I am using VS2010 as a client for a TFS instance. I created a workspace and you need to map the TFS directory to the local directory - call the local directory " D: \ aaa \ bbb \ ccc \ ddd ". When I go to "Manage workspaces" and click "edit" to change the local directory to this path, I get the following error: 1

This error occurs when I try to display: " D: \ aaa ", " D: \ aaa \ bbb ", " D: \ aaa \ BBB \ scc ".

Now, if I create a folder with the name: D: \ aaa \ bbb \ ccc1 \ ddd ", the mapping works, and I don't get this error.

Can anyone help? I pulled my hair out for about a day.

Thanks.

[EDIT01: I tried to map all other folders under the D: \ drive, and only one other folder does not display the display. I get the same error as with " D: \ aaa \ bbb \ ccc \ ddd "]

Answer 1

SQL errors

First of all, you should not receive SQL Error 18054 (or any SQL errors) from TFS.

You need your TFS administrator to connect to the SQL server hosting the DB master for your TFS server and run the following query:

 select * from master.dbo.sysmessages where error > 50000 

If it is a TFS2010 server, the TFS administrator can use TFSConfig PrepSql to reinstall error messages.

If it is a TFS2008 server, your TFS administrator will need to open Add or Remove Programs and start the repair in TFS.

Your actual problem

This sounds obvious at first, two local paths cannot point to the same storage location for the same workspace. However, one that catches a lot of people who do not know that you cannot have two path repositories mapped to the same local path to the same computer.

In TFS, you cannot have two folders with overlapping mappings. Since D:\aaa\bbb\ccc\ddd is a subfolder of D:\aaa , you cannot add it.

One thing you can do is cloak so that they are not part of the workspace comparisons. In your case, you can display D:\aaa and add a cloak for all other subfolders in this directory except D:\aaa\bbb .