Post reply

Add readonly user to secondary replica?

  • July 10, 2013 at 7:51 am

    #280129

    I am using an Availability Group to mirror a database from our prod environment to a disaster recovery environment. I set the secondary replica to be read-only. Can I create new logins on the DR environment and grant them read to the secondary replica?

    Thanks,

    DK

  • July 11, 2013 at 9:26 am

    #1631640

    As the database will be readonly you wont be able to make any changes to it specifically.

    So your best bet is to create the login at botht he primary and secondary and grant access at the primary source, then set the DENY status for the login on the primary.

    This will prevent connections at the primary server but allow connections at the secondary. This is how we have setup a log shipping reporting server and can't see why the same approach would not work in an availibility group setup.

    MCITP SQL 2005, MCSA SQL 2012

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply