Unable to delete workspaces for moved users

Hi,

We have had some misfortune in our active directory domain. Some users where moved by accident to a sub-domain and after discvovering that moved back to the originating domain. This caused of course an update of all SID's of the moved user accounts. The apptier recovered wunderful well with one glitch.

The existing workspaces of the users still remain leading to the strange effect that they cannot map a new workspace to the same folder and some users had still checkouts in that workspace.

Listing the workspaces shows the troubled workspaces with usernames postfixed with a number (unhappyuser:13) where there also exists workspaces for unhappyuser.

I tried the tf workspace /delete option and /tf workspaces /updateUsername:unhappyuser:13 to no avail. All this leads to the tf error: 50605: There was an error looking up the SID for unhappyuser:13.

I even digged in the datatier to find the previous SID for UnhappyUser and tried using that SID to delete the workspace without succes. As I'm out of options is there anyone who can lead me to a solution?

Tnx,

Rene

[1125 byte] By [reneschrieken] at [2007-12-27]
# 1

Try the TfsAdminUtil Sid command- I think that will fix the issue for you.

Cheers,
Adam

AdamSinger-MSFT at 2007-9-4 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Administration...
# 2

Hi Adam,

Thanks for responding.

I suppose you mean to run this command:

tfsadminutil sid /change [source] [target]

Do I enter for source the SID of the 'UnhappyUser' before his unfortunate removal and for target the current SID for 'UnHappyUser'? Obtaining the current sid can be done with tfssecurity but I so far only find the 'old' SID by poking around the identiy tables in the SQL Server on our data tier.

Is that the right procedure?

Rene

reneschrieken at 2007-9-5 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Administration...
# 3

I believe "source" and "target" are actually the domain names, and "account" is the account name. In this case, since you deleted and recreated users in the same domain, I would try "tfsadminutil sid /change <DOMAIN> <DOMAIN> <username>".

Hope this helps-

Cheers,
Adam

AdamSinger-MSFT at 2007-9-5 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Administration...
# 4

Hi Adam,

I did run the command tfsadmintuil sid /change ourdomain ourdomain ourdomain\unhappyuser

The output showed no errors, It showed the header of a list but it didn't output anything under the header. I'm not sure if this is indication of succes :-)

We'll wait for an hour to give the apptier time to update things and I'll recheck then if the problem still persists.

Rene

reneschrieken at 2007-9-5 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Administration...
# 5

I don't think you need to specify the domain as part of the user name. Instead, try: "tfsadminutil sid /change ourdomain ourdomain unhappyuser"?

It should print out a list of the users changed if it succeeds.

Cheers,
Adam

AdamSinger-MSFT at 2007-9-5 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Administration...
# 6

Hi Adam,

Ok, did that, I received notification that it found UnHappyUser and that it found the user in AD and that the SIDs equals.

I still have workspace now for UnHappyUser and UnhappyUser:15. Does it take time for the changes to become effective?

Rene

reneschrieken at 2007-9-5 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Administration...
# 7

it is based on the configuration u did on Warehouse...if you want to run manually...do the following..

Start ->Run ->inetmgr

under website...select team foundation server ..select warehouse..v1.0...browse the webservice warehousecontroller.asmx...you will get all list of operations...select RUN..and invoke...if it is showing as TRUE..then done..it will update the changes in the TFSWarehouse database...

Thanks, Kathir

Kathirvel at 2007-9-5 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Administration...
# 8

At this point I would try the command you ran earlier - "tf workspaces /updateUsername:unhappyuser:13" - to see if that can update the owner of the workspace.

Cheers,
Adam

AdamSinger-MSFT at 2007-9-5 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Administration...
# 9

Ok, the

tfsadminutil sid /change domain domain UnhappyUser

did the trick. The unHappy user was able to delete the no longer needed workspace. We have a HappyUser now!

Thanks for the support.

Rene

reneschrieken at 2007-9-5 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Administration...
# 10
I will try that for one of the remaining accounts. I'll update my progress here
reneschrieken at 2007-9-5 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Administration...

Visual Studio Team System

Site Classified