Post reply

read access to user in secondary replica

  • May 5, 2020 at 12:51 pm

    #3748923

    i created  a user  on primary replica  and provided access to one  of the database. I need  the user to selcct the data  from the secondary with out accessing the  primary replica, how can i give the read access to the user on secondary replica for this purpose

  • May 5, 2020 at 1:16 pm

    #3748932

    The user must exist as a login on both sides (unless your in contained database territory)

    You then also need to ensure your licensed correctly, as allowing a user access to the secondaries to run queries is classed as production use and now the secondary MUST be licensed accordingly.

    You then configure readable secondaries, plenty of information on this on a Google/Bing search.

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

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