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

Copy accounts to secondary log shipping server Expand / Collapse
Author
Message
Posted Friday, March 11, 2011 9:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, March 11, 2011 9:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 29, 2011 11:30 AM
Points: 2, Visits: 17
I figured it out.
Post #1076995
Posted Thursday, May 26, 2011 2:00 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 7:47 AM
Points: 45, Visits: 312
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
Posted Thursday, May 26, 2011 4:09 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:38 AM
Points: 5,879, Visits: 13,010
Coozie has duplicated posted here but it is good forum etiquette to post your resolution to an issue to help others.

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

Post #1115915
Posted Thursday, May 26, 2011 4:49 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 18, 2014 3:04 AM
Points: 1,331, Visits: 15,269
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 »

Add to briefcase

Permissions Expand / Collapse