Post reply

How to configure mirroring with certificates.

  • March 17, 2016 at 8:16 am

    #324966

    Hi,

    I need to know how to configure mirroring with certificates. What r the common issues that might occur and how to fix. Please guide.

    Also any useful links ?. Thanks in advance.

    San.

  • March 18, 2016 at 3:36 pm

    #1866228

    Example: Setting Up Database Mirroring Using Certificates

    https://msdn.microsoft.com/en-us/library/ms191140(v=sql.100).aspx

  • March 20, 2016 at 11:01 pm

    #1866367

    Another helpful post: https://blogs.msdn.microsoft.com/sqlblog/2011/08/24/setting-up-database-mirroring-with-certificates/ [/url]

  • March 25, 2016 at 8:05 pm

    #1867825

    Incase you are implementing witness server as well then it gets a little bit complicated.

    Make sure you have created its own certificate on the witness server and on the principal and the mirror server you create user authorization using this witness certificate.

    Same thing needs to be done on the witness server as well.You create two user authorization using individual certificates from the principal and the mirror server.

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server

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

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