Copy accounts to secondary log shipping server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Copy accounts to secondary log shipping...

Copy accounts to secondary log shipping server

Rate Topic

Display Mode

Topic Options

Author

Message

klittlejohn

Posted Friday, March 11, 2011 9:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 29, 2011 11:30 AM
Points: 2, Visits: 17

We just implemented log shipping and use the secondary DB server for reporting. How can I add the existing users on the primary server to the secondary DB so they can access the database. Do i need to create a new account on the primary server, get the SID and create a new account on the secondary server with the same SID or can i migrate the existing accounts over to the secondary server? Help is greatly appreciated and thanks in advance!

Post #1076972

klittlejohn

Posted Friday, March 11, 2011 9:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 29, 2011 11:30 AM
Points: 2, Visits: 17

I figured it out.

Post #1076995

Coozie

Posted Thursday, May 26, 2011 2:00 PM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 1:17 PM
Points: 39, Visits: 244

Would you be able to let me know what you did to fix this?

I have implemented log shipping and now they want me to add a new sql server account.

I added the account to the primary.
Then I used the sid from primary to create the account on the secondary master database.

Problem is: The user account doesn't show up in the secondary databases.

How do you add new accounts to the primary and get them to show up in the secondary?

Thanks,
Mark

Post #1115826

george sibbald

Posted Thursday, May 26, 2011 4:09 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:22 AM
Points: 5,264, Visits: 11,192

Coozie has duplicated posted here but it is good forum etiquette to post your resolution to an issue to help others.

---------------------------------------------------------------------

Post #1115915

MysteryJimbo

Posted Thursday, May 26, 2011 4:49 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 06, 2013 8:14 AM
Points: 1,125, Visits: 14,510

Its also a good idea to disable the login at the source (if possible) to prevent accidental access there

Post #1115930

« Prev Topic | Next Topic »

Permissions