Remove 5 Users from Team Foundation server workgroup Edition

Release Team Foundation server workgroup Edition 5 User restrictionsBecause all users must be added to the team Foundation licensed Users Group to connect to TFS, you only need to manually modify the database to crack the limit of 5 users. We use the tfsguest4 account for testing.
The procedure is as follows:
First, we connect to the team Foundation server with the account of the team Foundation server administrator. Then, we add users to the team Foundation licensed users group. If there are more than five users, the following message is displayed: to crack the limit on the number of users (5), let's manually modify the database: 1. first, assign the tfsguest4 account permissions. For example, assign the permissions to [project]/contributors as follows: 2. select properties to go to the following window: 3. select Windows user or group (W), click Add, and then select tfsguest4. The operation is as follows: 4. click OK. 5. enable SQL Server 2005, use SQL management studio to connect to your database server, and find table 6 of "tbl_security_identity_cache" in the "tfsintegration" database. right-click a table and choose "Open table". Find its Sid using an SQL statement, or use an SQL script to process the select Sid from tbl_security_identity_cachewhere display_name = n' tfsguest4' and deleted = 0. Note: add n to the Chinese user name. that is, where [display_name] = n 'zhang san'; Deleted field: whether the field has been deleted; 0 indicates: not deleted; 1 indicates: 7. then, use the SQL statement to query the SID of the team Foundation licensed users group. Select Sid from tbl_security_identity_cache where (display_name = n' team Foundation licensed users ') and (Deleted = 0) 8. open the "tbl_security_membership_cache" table, as shown below: 9. after opening, add the Sid found in 7 to the "iner" field in the last line; Add the Sid 6 to the "member" field; 10. add the Sid found in 7 to the "tbl_gss_group_membership" table; Add the Sid found in 7 to the "parent_group_sid" field; set the time for the "last_update" field; similar to Step 9: Note: Step 6-11. You can use an SQL script to add users to the team Foundation licensed Users Group for processing: declare @ container. Varchar( 100), @ Member Varchar( 100) Select @ Container = [Sid] from [tfsintegration]. [DBO]. [tbl_security_identity_cache] Where [display_name] = n' team Foundation licensed users 'and deleted = 0 select @ member = [Sid] from [tfsintegration]. [DBO]. [tbl_security_identity_cache] Where [display_name] = n' tfsguest4 'and deleted = 0 insert [tfsintegration]. [DBO]. [tbl_security_membership_cache] ([container], [member]) values (@ container, @ member) insert [tfsintegration]. [DBO]. [tbl_gss_group_membership] ([parent_group_sid], [member_sid], [last_update]) values (@ container, @ Member, getdate ()) run the above Code with the query analyzer. (You only need to execute it once) If you accidentally delete all "Team Foundation licensed users" Users in the group ; Cannot log on TFS Now , You can also use the above script method ; Change the account name. OK Now ;