Share via

How to have active and passive node configuration for Azure Database

Srikanth Vanam (PERSISTENT SYSTEMS LIMITED) 0 Reputation points Microsoft Vendor
2024-04-04T13:48:22.89+00:00

Hello,

We have DEV, UAT and PROD environments where we have our SQL Server and Database respectively.

We want to have active and passive node configuration so that we don't have issues when the database gets down. Kindly help on how to setup active and passive node configuration.

I have searched online but did not find much help. Thank you.

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 19,176 Reputation points Microsoft Employee
    2024-04-04T19:26:42.2366667+00:00

    @Srikanth Vanam (PERSISTENT SYSTEMS LIMITED) Thank you for reaching out.

    Did you go through this article.? It has detailed information for the above scenario.

    https://learn.microsoft.com/en-us/mem/configmgr/core/servers/deploy/configure/site-server-high-availability

    Make sure to install the SQL Server Native Client. If you don't install it, the prerequisite checker during Configuration Manager setup will report an error about missing SQL Server permissions.

    Regards,

    Oury

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.