Solution: tf10216: Team Foundation services are currently unavailable

After loading tfs2008, I thought everything was normal. After accessing the client, I found a strange phenomenon.
Only adminitrator can log on. Other users, whether added to the Administrator Group of the local machine or to the TFS Administrator group, cannot log on to the Administrator group.
Find it online...
TFS and users must be added to the license group first. In this way, you can use it normally.

Note: tfs2008 is a 5-user version by default.
(Switch) Remove the restriction on five users of team Foundation Server

Because all users must be added Team Foundation licensed users The Group can be connected. TFS; Therefore, you only need to manually modify the database to crack it. 5 User restrictions. We use Tfsguest4 Account for test .
The procedure is as follows:
  First Team Foundation Server Administrator Account connection Team Foundation server; Then we Team Foundation licensed users Add User to group ; If 5 Users will be prompted as follows: :

 

To crack the limit of the maximum 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 Connect to Your Database Server ; Find "Tfsintegration" Under the database "Tbl_security_identity_cache" Table 6. Right-click " Open Table "; Use SQL Statement to find its Sid; Or Direct useSQLScript Processing   Select Sid From Tbl_security_identity_cache Where Display_name = N 'Tfsguest4' And Deleted = 0 Note: : Add the chinese user name before N. That is: Where [display_name] = N' Zhang San '; Deleted Field : Deleted? ; 0 Indicates : Not deleted ; 1 Indicates : Deleted The execution is as follows: : 7. And then use SQL Statement Query Team Foundation licensed users Group Sid; Select Sid From Tbl_security_identity_cache Where (Display_name = n' team Foundation licensed users ') And (Deleted = 0)

 

8. Then open " Tbl_security_membership_cache " Table ; As follows: :

 

9. After opening ; In the last line " Container" Add to field 7TheSid; In " Member " Add to field 6QueryOutputSid; 10. In " Tbl_gss_group_membership " Add Table ;" Parent_group_sid " Add to field 7TheSid, " Member_sid " Add to field 6DetectedSid; " Last_update " Field time ; And 9 Similar operations : Note : 6-11 Procedure ; You can use one SQL Script to add users Team Foundation licensed users Group 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] ) S ( @ Container , @ Member ) Insert [Tfsintegration]. [DBO]. [tbl_gss_group_membership] ( [Parent_group_sid] , [Member_sid] , [Last_update] ) S ( @ Container , @ Member , Getdate ()) SetCodeRun the query analyzer. ;( Only 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 ;