解除TFS的License组中的用户数已达到最大用户数限制！
TFS中所有的用户必须加入到Team Foundation Licensed Users组内才能连接上TFS，如果提示超过5用户限制的话，可以通过数据库来破解5用户限制：
例如你新添加的用户名是：tfstestuser;
先将用户tfstestuser添加到[项目名称]\Contributors(参与者)组；
然后在打开TFS数据库管理器并登录，执行下面的SQL语句代码即可：
1 USE [TfsIntegration]
2 GO
3
4 DECLARE @LicensedUsersSID VARCHAR(100), @MemberSID VARCHAR(100), @MemberName VARCHAR(100);
5
6 SET @MemberName = 'tfstestuser';
7
8 SELECT @LicensedUsersSID=[sid] FROM [TfsIntegration].[dbo].[tbl_security_identity_cache]
9 WHERE ([display_name]=N'Team Foundation Licensed Users') AND (deleted=0);
10
11 SELECT @MemberSID=[sid] FROM [TfsIntegration].[dbo].[tbl_security_identity_cache]
12 WHERE ([display_name]=@MemberName) AND (deleted=0);
13
14
15 INSERT [TfsIntegration].[dbo].[tbl_security_membership_cache] ([container],[member]) VALUES (@LicensedUsersSID,@MemberSID);
16 INSERT [TfsIntegration].[dbo].[tbl_gss_group_membership] ([parent_group_sid], [member_sid], [last_update]) VALUES (@LicensedUsersSID, @MemberSID, getdate());
17
18 GO
19
2 GO
3
4 DECLARE @LicensedUsersSID VARCHAR(100), @MemberSID VARCHAR(100), @MemberName VARCHAR(100);
5
6 SET @MemberName = 'tfstestuser';
7
8 SELECT @LicensedUsersSID=[sid] FROM [TfsIntegration].[dbo].[tbl_security_identity_cache]
9 WHERE ([display_name]=N'Team Foundation Licensed Users') AND (deleted=0);
10
11 SELECT @MemberSID=[sid] FROM [TfsIntegration].[dbo].[tbl_security_identity_cache]
12 WHERE ([display_name]=@MemberName) AND (deleted=0);
13
14
15 INSERT [TfsIntegration].[dbo].[tbl_security_membership_cache] ([container],[member]) VALUES (@LicensedUsersSID,@MemberSID);
16 INSERT [TfsIntegration].[dbo].[tbl_gss_group_membership] ([parent_group_sid], [member_sid], [last_update]) VALUES (@LicensedUsersSID, @MemberSID, getdate());
17
18 GO
19
