Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

logins Expand / Collapse
Author
Message
Posted Sunday, June 15, 2008 10:27 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650
HI to all .
Is there any procedure to copy the logins.
In logshipping logins are not transferred .
Is there any standard approach to copy the logins and move it to the secondary server.


Thanks,
Sandhya.
Post #517353
Posted Sunday, June 15, 2008 10:38 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 8:19 PM
Points: 1,393, Visits: 438
Create an Integration Services package and schedule it to run daily/weekly, depending how often you add/remove logins. There is a "Transfer Logins Task" where you can select the logins that would have to be transferred along with some conditions; it's important to set "copySids" to True.
Good luck



Post #517355
Posted Sunday, June 15, 2008 11:52 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, October 26, 2012 2:14 PM
Points: 402, Visits: 598
Here is a procedure to script the logins, but for log shipping you can make use of transfer login tasks as mentioned abovehttp://support.microsoft.com/kb/246133


- Deepak
Post #517365
Posted Monday, June 16, 2008 8:19 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
We tend to use the method specified in the Microsoft KB article. We also script out the logins and store it in a location that gets backed up to tape (which is then stored off-site) for disaster recovery situations.


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #517585
Posted Monday, June 16, 2008 2:16 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 20, 2013 4:45 AM
Points: 236, Visits: 239
Deepak's link will give you what you want. Its been improved since I last needed it. Default databases etc. The key thing is the copying of the SIDs.
Post #517874
Posted Monday, June 16, 2008 2:30 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
Preet (6/16/2008)
Deepak's link will give you what you want. Its been improved since I last needed it. Default databases etc. The key thing is the copying of the SIDs.


This is a good point. The Microsoft scripts do ensure the SID is carried over. This is important because that's how the login maps into the database as a user. Without using the Microsoft scripts, you'd have to run sp_change_users_login to reconcile whenever you had to switch-over to the standby system.


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #517882
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse