Accidentally deleted the users in the "Team Foundation licensed users" group and then restored them.

Use the client of vs2005 to connect to TFs. If you do not enter the user name and password, you can log on to the console as an administrator. In this case, you can find the permission settings in team explorer, I found a team Foundation licensed users group with an administrator in it, so I was curious to delete it and the result would no longer be connected to TFs, result The SQL Server 2005 trace is found to be dead in the following statement:

Exec Sp_executesql n ' -- Prc_security_read_is_member
Declare @ ismember bit
Exec prc_security_read_is_member @ Sid, @ groupsid, @ ismember output
Select @ ismember
' , N ' @ Sid varchar (46), @ groupsid varchar (59) ' , @ Sid = ' S-1-5-21-2604840842-1608877906-3008711727-1113 ' , @ Groupsid = ' S-1-9-1551374245-1204400969-2402986413-2179408616-0-0-0-0-4 '

This SP is an SP in tfsintegeration, but it is encrypted and cannot be viewed. So I searched for the table and found that three tables may be associated: tbl_gss_group_membership, tbl_security_membership_cache, and tbl_security_ismember_cache. Then I added data to the table one by one and added it to the third, success. The following statements:

Insert   Into Tbl_gss_group_membership (parent_group_sid, member_sid, last_update)
Values ( ' S-1-9-1551374245-1204400969-2402986413-2179408616-0-0-0-0-4 ' , ' S-1-5-21-2604840842-1608877906-3008711727-1113 ' , Getdate ())

insert into tbl_security_membership_cache (container, member)
values ( ' S-1-9-1551374245-1204400969-2402986413-2179408616-0-0-0-0-4 ' , ' S-1-5-21-2604840842-1608877906-3008711727-1113 ' )

Insert IntoTbl_security_ismember_cache (Group, Member)
Values('S-1-9-1551374245-1204400969-2402986413-2179408616-0-0-0-0-4','S-1-5-21-2604840842-1608877906-3008711727-1113')