User Migration

Our team is currently using the NT Authentication module for TC login. We are now being required to move onto a new domain (that of our parent company) and so all of our machines are being moved into the new domain and we will have new logins in the domain. Is there any way to migrate (even manually) our existing TC accounts, based off of the old domain credentials, to the new one?

Thanks,
Ray

3 comments

This should work if usernames are preserved. Right now TeamCity does not check the user domain. The only place where domain name is shown is in the user list page (Administration tab). To fix this you can update users table and set new domain in the realm column:
UPDATE TABLE users SET realm = 'new domain name' WHERE realm = 'old domain name'

--
Pavel Sher

0

Unfortunately, user names will be changing. It looks like the USERS table has an ID field that is used as a foreign key by referencing tables (at least from looking at USER_ROLES). Is the ID always used? If so, I think it should be safe enough to update USERNAME as well as REALM. Could you confirm this?

Thanks,
Ray

0

The ID is unique identifier used everywhere when a user account is required, except authorization because in this case user accounts are located by username. So the answer is yes, you can safely update username and realm columns. But do not forget to make a backup.

--
Pavel Sher

0

Please sign in to leave a comment.