What I am trying to do is relink a database user to a new domain user, and also keeping the same database user name.
I am able to do this when I run the following command, and if the database user isn't the same as the login name.
alter user TestUser2 with name= TestUser2, login= [BBATestUser1]
But what happen is when the database user is the same as my login name, CCTestUser2, I can't relink it.
So when I run
alter user [CCTestUser2] with name= [CCTestUser2], login= [BBATestUser1]
I get the following error
"The name change cannot be performed because the SID of the new name does not match the old SID of the principal."
I think this occur cause sid of [CCTestUser2] and [BBATestUser1] is different.
How can I resolve this, cause some of my database user name has the same name as my login name.
Thanks in advance.