August 8, 2012 at 6:46 am
I have a sql 2005 server that supports a 3rd party app. Users connect with win/sql authentication, the 3rd party app then has an interface to add the users to the database. In sql logins you see
mydomain\myname. In the users in the database you only see myname. We are converting domains, which means I need to script out all logins and users. The trick is now the login will be
newdomainame\myname. The usernames in the database could stay the same but would be mapped to the old logins. At the login level I know how to script them all out and then do a quick replace with the new domain name. The trick is the users and either scripting them out out making sure when the logins go back in that they are mapped to the correct users. Any ideas on how to handle this?
Thanks
August 16, 2012 at 2:24 pm
No need to script them out. You can generate a command like this for each user with the new login for each. Just make sure you supply the NAME option and reiterate the name you want for the user otherwise SQL Server will rename the user to the new login name:
ALTER USER [User.Name] WITH LOGIN = [NEWDOMAIN\User.Name], NAME = [User.Name];
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply