在TFS中映射本地目录时发生数据库错误（SQL错误18054） [英] Database error occurred (SQL error 18054) when mapping local directory in TFS

问题描述

我将VS2010用作TFS实例的客户端。我创建了一个工作区，需要将TFS目录映射到本地目录-我们将本地目录称为 D：\aaa\bbb\ccc\ddd 。当我导航到管理工作区并单击编辑以将本地目录更改为此路径时，出现以下错误： 1

I'm using VS2010 as a client for a TFS instance. I created a workspace, and need to map a TFS directory to a local directory - let's call the local directory "D:\aaa\bbb\ccc\ddd". When I navigate to "Manage Workspaces" and click "edit" to change the local directory to this path, I am presented with the following error: 1

当我尝试映射时出现此错误： D：\aaa ， D：\aaa\bbb ， D：\aaa\bbb\ccc 。

This error occurs when I try to map: "D:\aaa", "D:\aaa\bbb", "D:\aaa\bbb\ccc".

现在，如果我创建一个名为 D：\aaa\bbb\ccc1\ddd 的文件夹，该映射将起作用，并且不会收到此错误。

Now, if I create a folder called: "D:\aaa\bbb\ccc1\ddd", the mapping works, and I do not receive this error.

有人可以帮忙吗？我已经为此花了大约一天的时间。

Can anyone help? I've been pulling my hair out for about a day over this.

谢谢。

推荐答案

SQL错误

首先，您不应从TFS收到SQL错误18054（或任何SQL错误）

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

您应该让TFS管理员连接到SQL Server，该SQL Server为TFS服务器托管 master 数据库，并运行以下查询：

You should have your TFS administrator connect to the SQL server that hosts the master DB for your TFS server and run the following query:

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

如果这是TFS2010服务器，则您的TFS管理员可以使用 TFSConfig PrepSql 重新安装错误消息。

If this is a TFS2010 server, your TFS administrator may be able to use TFSConfig PrepSql to re-install the error messages.

如果这是TFS2008服务器，则您的TFS管理员需要打开添加/删除程序并在TFS上运行修复。

If this is a TFS2008 server, your TFS administrator will need to open Add/Remove programs and run a repair on TFS.

您的实际问题

乍一看，两个
本地路径无法指向对于相同的
工作区，在存储库中具有相同的
位置。但是，
引起很多人不了解的情况是
，您不能将两个存储库
路径映射到同一台
上的本地路径。

This sounds obvious at first, two local paths cannot point to the same place in the repository for the same workspace. However, the one that catches a lot of folks un-aware is that you cannot have two repository paths mapped to one local path on the same computer.

在TFS中，不能有两个具有重叠映射的文件夹。由于 D：\aaa\bbb\ccc\ddd 是 D：\aaa ，则无法添加。

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

您可以做的一件事是斗篷文件夹，使它们不属于文件夹工作区映射。在您的情况下，您可能想映射 D：\aaa 并为该目录中的所有其他子文件夹添加一个斗篷，但 D除外： \aaa\bbb 。

One thing you can do though, is cloak folders so that they aren't part of the workspace mappings. In your case, you might want to map D:\aaa and add a cloak for all the other subfolders in that directory, except for D:\aaa\bbb.

这篇关于在TFS中映射本地目录时发生数据库错误（SQL错误18054）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！