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