Share via

AAD Connect on SQL HA

shashidhar joliholi 276 Reputation points
2023-01-04T09:38:39.633+00:00

Hi All,

We are planning to use SQL HA for the AAD Connect tool for active and staging servers. Primary will be configured with a SQL AOA listener name and instance name. Can we use the same instance for staging or do we need to create a separate instance for staging? Can both active and staging use the same DB?

Need your help!
Shashidhar Joliholi

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,959 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Givary-MSFT 35,126 Reputation points Microsoft Employee
    2023-01-04T10:24:22.313+00:00

    @shashidhar joliholi Thank you for reaching out to us. As I understand you have query on AAD Connect on SQL HA. As far i know Primary & staging Azure AD Connect servers should use different instance & different DB.

    Having them ( primary & staging AAD Connect) on same instance & same DB doesnt solve the HA purpose.

    Let me know if you have any further questions, feel free to post back.

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.