How to rename domain accounts in SQL

Hi, I am trying to copy logins from one server to other and I need to rename the login's(domain accounts) on the second server.when I tried to rename I am getting the below error .What is the best approach for this.
"Msg 15151, Level 16, State 1, Line 1 Cannot alter the user 'RBW439365', because it does not exist or you do not have permission."

asked Feb 15 '12 at 05:19 PM in Default

srivivek
519 ● 30 ● 39 ● 42

If an answer is helpful, make sure you vote it up by clicking on the thumbs up symbol next to it. If an answer solves the issue, be sure you mark it by clicking on the check box next to it.

Feb 08 at 03:22 PM Grant Fritchey ♦♦

(comments are locked)

1 answer:

A domain account has to be renamed at the domain level.

Are you looking to create an alias for the name? Is the server in a different domain? I'm not clear on why you want to rename them.

The benefit of domain accounts is that the same one is used on any authorized system in the environment.

answered Feb 15 '12 at 06:20 PM

Blackhawk-17
10.5k ● 23 ● 29 ● 34

one server is DEV and and other server is IST,our company policy is the account names should be different in both environments.

Feb 15 '12 at 06:31 PM srivivek

Then you will require new domain accounts for the DEV environment to associate with the database users.

Feb 15 '12 at 06:45 PM Blackhawk-17

To follow company policy you would have to create different accounts at the domain level for each user, then add those to the instance.

I can understand having different accounts for administrative purposes but not really for developers. If you have a large number of accounts already, you are talking about doubling that which is going to be a lot of overhead to maintain. I would instead restrict their access by using Windows Groups assigned to the dev and production instances. Just my opinion.

Feb 15 '12 at 06:54 PM Shawn_Melton

(comments are locked)