TFS user migration from one domain to another

we running tfs 2010 sp1.

problem background: recently, due internal reasons, needed migrate several users 1 domain another. actually, "migration" not migration @ - our local ad admins created new user accounts in domain , adjusted acls on file , print servers, after that, we were told use new accounts instead of the old ones, there no sid history attached new accounts. provided, no-one cared migrate tfs users, had log pc old account , use "run as... (new account)" in order connect corporate resources.

two days ago tried migrate 1 tfs user "tfsconfig identities /change /fromdomain:<olddomain> /todomain:<newdomain> /account:<olduser> /toaccount:<newuser>" command, ended broken tfs configuration user. when run command, reported success, however, "tfsconfig identities" lists both accounts (old , new one) now, there no changesets associated new account, moreover, new account cannot see workitems in project, plus, attempt create , save new workitem results in "tf26212: team foundation server not save changes. ..."

any highly appreciated!!! thank in advance.

hi john,

yes, our tfs server installed in old domain. and, yes, have trust relationship configured between 2 domain - doubt if successfully run "tfsconfig identities /change" if there no relationship between domains configured.

nevertheless, after day of digging tfs database structure, managed fix tf26212 error directly modifting records in constants table of the [tfs_??? collection] database.

begin tran  declare @olddomain varchar(255) = 'olddomain'; declare @oldaccount varchar(255) = 'oldaccount'; declare @newdomain varchar(255) = 'newdomain'; declare @newaccount varchar(255) = 'newaccount';  declare @oldteamfoundationid uniqueidentifier; declare @oldconstid int;  select	@oldteamfoundationid = teamfoundationid, 		@oldconstid = constid constants domainpart = @olddomain , namepart = @oldaccount  declare @newteamfoundationid uniqueidentifier; declare @newconstid int;  select	@newteamfoundationid = teamfoundationid, 		@newconstid = constid constants domainpart = @newdomain , namepart = @newaccount;  update constants set teamfoundationid = @oldteamfoundationid constid = @newconstid;  update constants set teamfoundationid = @newteamfoundationid constid = @oldconstid;  commit tran

i still can see both accounts in "assigned to" dropdown list of workitem editor, plus, previous check-ins associated old account, @ least i can work now!!!

ps. i'm aware not recommended to change raw data in tfs databases, but, provided, there no documented way revert account migration back, had in order restore tfs access.

Archived Forums V  >  Team Foundation Server - Setup and Administration