how to configure 2 DC server and 1DR server mirror in 2016 sql server RRS feed

Všechny reakce

  • Hi ajit kumar1991,

    When configuring your data environment and planning servers and installs, it is important to understand that Microsoft does not recommend that you install SQL Server on a Domain Controller.  While you technically CAN, there are some dangers involved that you should be aware of before you do this.

    1.SQL Server Services cannot be run using a Local Service account.
    2.A Domain Controller with SQL Server installed on it cannot be demoted to a Domain Member or promoted to a Domain Controller.
    3.aving your Domain Controller host SQL Server installs poses security risks.
    4.Failover clustering best practices will not be supported in this configuration.

    Please refer to Installing SQL Server on a Domain Controller: What You need to know.

    If you still want to install SQL server on a DC, please refer to How to Install Microsoft SQL on a Domain Controller.

    For configuring database mirroring, I suggest you follow below steps to configure it by T-SQL. Please refer to Configure Database Mirroring.

    For setting up Active Directory, please refer to Step-By-Step: Setting up Active Directory.

    Hope this could help you.

    Best regards,
    Cathy Ji

    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

    středa 17. července 2019 6:12