locked
In environment 2 DC server in Failover clustering(Active/Passive) and 1DR server standalone in 2016 RRS feed

  • Question

  • In environment  2 DC server in  Failover clustering(Active/Passive)  and 1DR server standalone  in 2016 Sql server, I want to mirroring in DC - DR

    ajitkumar

    Saturday, September 7, 2019 9:56 AM

All replies

  • Hi ajitkumar,

     

    The biggest problem is that stand-alone sql server does not have an FQDN since it is not in a domain. SQL Server requires you to use FQDN formatting for the partner addresses. When you're trying to configure it.  Please refer to  How to configure SQL Server database mirroring between 2 instances on a standalone server

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, September 9, 2019 6:21 AM