Post reply

Logins on mirror server

  • August 18, 2016 at 12:27 pm

    #329469

    I am setting up database mirroring on a test environment.

    So I am creating the logins on principal server, do I have the create the same logins on the mirror server also?

    and we have user and database roles on principal server, Do I have to create them on the mirror database server too?

    if so, when should I create it? as the database will be in restoring mode

    if not, after failing over how will the users connect to the mirror server?

    Thanks

  • August 18, 2016 at 12:43 pm

    #1896233

    Do I have the create the same logins on the mirror server also?

    Yes

    Do I have to create them on the mirror database server too?

    They should come over automatically when you restore the database with no recovery during the initial mirror setup

    After failing over, how will the users connect to the mirror server?

    As long as the logins exist on the mirrored sql instance, the users should be able to connect without issues

  • August 18, 2016 at 12:53 pm

    #1896235

    Thanks.

    So after the failover has occurred, I should map the logins to the database?

  • August 18, 2016 at 1:09 pm

    #1896238

    You should not have to. They should already be mapped.

Viewing 4 posts - 1 through 3 (of 3 total)

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