Share via

AADC auto upgrade with external SQL

James Edmonds 831 Reputation points
2021-12-21T15:32:10.733+00:00

Hi,

I have two questions around Azure AD Connect (AADC) deployment and configuration;

  1. Can I used auto upgrade if I am using an external SQL server, or is auto upgrade explicitly only supported for express settings/local SQL DB installs?
  2. If I use an external SQL server, how do I create a gMSA to run the service as? I have never used gMSA and I do not understand the MS documentation on this.

Many thanks.
James

Microsoft Security | Microsoft Entra | Microsoft Entra ID
0 comments
Accepted answer
  1. Siva-kumar-selvaraj 15,721 Reputation points
    2021-12-22T13:34:18.657+00:00

    @James Edmonds ,

    Thanks for sharing your findings here. Yes, Azure AD connect auto Upgrade Not Supported in NonLocalDb scenarios such as external SQL.

    Auto-upgrade eligibility : https://learn.microsoft.com/en-us/azure/active-directory/hybrid/how-to-connect-install-automatic-upgrade#auto-upgrade-eligibility

    ----
    Please "Accept the answer" as this will help others in the community.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. James Edmonds 831 Reputation points
    2021-12-22T12:18:02.307+00:00

    We had it confirmed by MS support that auto upgrade is NOT supported when using external SQL.
    We will just proceeding with a local DB install for the sake of simplicity, and to take advantage of auto upgrade.

    1 person found this answer helpful.
    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.