August 12, 2009 at 7:27 am
Hi -
I was wondering if there was an easy way to change a login name that I'm overlooking. I need to change it from domain\qa_sqluser to domain\prod_sqluser. I have tried an alter login statement but received 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.'
Any help would be greatly appreciated! Thanks in advance!
August 12, 2009 at 10:54 am
I think you're getting that message because the login wasn't renamed in Windows i.e. both logins exist. I think your only option is to add domain\prod_sqluser as a login in SQL Server and replace database users before dropping domain\qa_sqluser.
We had to go through this when we implemented a new domain side-by-side with an existing domain which resulted in two logins for each person, each with a different SID. We just plodded through each SQL instance, adding the new logins, finding where the old ones were used and substituting the new ones.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply