domain conversion and logins and users

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » domain conversion and logins and users

domain conversion and logins and users

Rate Topic

Display Mode

Topic Options

Author

Message

timscronin

Posted Wednesday, August 08, 2012 6:46 AM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, May 10, 2013 7:54 AM
Points: 472, Visits: 686

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

Post #1341824

opc.three

Posted Thursday, August 16, 2012 2:24 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 6,696, Visits: 11,713

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1346237

« Prev Topic | Next Topic »

Permissions