moving logings from sql server 2008 to 2008

Question

Post reply

moving logings from sql server 2008 to 2008

bmw110001

Old Hand

Points: 391
More actions
July 24, 2012 at 2:48 am

#264665

Hi
R there any steps to transfer logins from 2008 to 2008

BrainDonor SSCoach Points: 19254 More actions · Answer 1

SSIS can be used for this - http://msdn.microsoft.com/en-us/library/ms137870(v=sql.100).aspx.

Steve Hall
Linkedin
Blog Site

Ant-Green SSC Guru Points: 113507 More actions · Answer 2

Many different ways

1. Right click the login, select script login as, then create to new query window

2. Google "sp_help_revlogin"

3. SSIS Transfer logins task

4. Manually recreate them on the second server

Also google ALTER LOGIN and sp_change_user_login as you will need to map the SID's (for SQL logins only) to access the databases if you transfer databases between servers.

DBA328 Hall of Fame Points: 3952 More actions · Answer 3

The stored procedure sp_help_revlogin could do this, refer to following article:

http://support.microsoft.com/kb/918992

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 4

anthony.green (7/24/2012)
2. Google "sp_help_revlogin"

This is the preferred method for any migrations involving SQL Logins as the SID's are included and remove the need to fix orphaned logins

Ant-Green SSC Guru Points: 113507 More actions · Answer 5

I personally tend to miss out the SID part when running the script to the other server, just my personal preference.

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 6

anthony.green (7/24/2012)
I personally tend to miss out the SID part when running the script to the other server, just my personal preference.

Making work for yourself there.

Ant-Green SSC Guru Points: 113507 More actions · Answer 7

Yep totally agree on that, just half the time the developers create logins which arn't needed so it just adds that extra security step when promoting to test and live.