idea Add support for Azure AD authentication for geodatabases in Azure SQL DB or Azure Managed Instance. in ArcGIS Pro Ideas

Add support for Azure AD authentication for geodatabases in Azure SQL DB or Azure Managed Instance.

AndrewRudin1 — Tue, 13 Dec 2022 21:41:39 GMT

When moving to Azure, many organizations implement Azure AD as a single source of authentication within the Azure environment. However, when connecting ArcGIS Pro to an Azure SQL Database or Managed Instance, the connection properties window does not provide the user an option to choose "Azure Active Directory" for the authentication.

Please add this as an option so, we can manage access to our geodatabases in Azure the same way we manage access to other Azure resources within our organization.

Re: Add support for Azure AD authentication for geodatabases in Azure SQL DB or Azure Managed Instance. - Status changed to: Needs Clarification

SSWoodward — Wed, 11 Jan 2023 00:13:41 GMT

Thanks for the idea

As of Pro 3.0 users are able to connect to an Azure SQL database using Azure Active Directory. When accessing the authentication options through the connection properties window, two authentication schemes are accessible, Azure Active Directory Universal with MFA and Azure Active Directory Password.

Do either of these authentication options match the intent of your Idea?

Re: Add support for Azure AD authentication for geodatabases in Azure SQL DB or Azure Managed Instance.

AndrewRudin1 — Wed, 11 Jan 2023 15:46:24 GMT

That's great, so yes that fulfills my idea. I'm on Pro 2.9 and didn't realize this option was added in 3.0. In parallel on the ArcGIS Enterprise side, does Enterprise 11.0 add the ability for the server to authenticate with an Azure SQL database in a similar way using a service account in Azure AD?

Re: Add support for Azure AD authentication for geodatabases in Azure SQL DB or Azure Managed Instance. - Status changed to: Already Offered

SSWoodward — Wed, 11 Jan 2023 19:26:27 GMT

Yes @AndrewRudin1 , that functionality is now available.

I've included a link for more information on what's new in ArcGIS Enterprise 11.0 on Azure if you are interested in seeing what other functionality has been added in the latest version.

Link - What's new in ArcGIS Enterprise on Microsoft Azure

Re: Add support for Azure AD authentication for geodatabases in Azure SQL DB or Azure Managed Instance.

MattMoore — Tue, 31 Oct 2023 13:29:09 GMT

@SSWoodward how does this apply to ArcGIS Enterprise, specifically ArcGIS Server 10.9.1 versus 11.1? I'd imagine 11.1 supports this but what about 10.9.1?

Re: Add support for Azure AD authentication for geodatabases in Azure SQL DB or Azure Managed Instance.

SSWoodward — Wed, 01 Nov 2023 17:31:38 GMT

@MattMoore this was added as new functionality at ArcGIS Server 11.0. Users operating on 10.9.1 will not be presented with this option.