Hi,
We are experiencing an issue connecting ArcGIS Pro 3.5 to an Azure SQL Server Managed Instance using Microsoft Entra authentication.
Environment:
Database: SQL Server Managed Instance on Azure Cloud
Client Application: ArcGIS Pro 3.5
Workstation: Both SSMS and ArcGIS Pro are installed on the same machine.
Problem Description:
As per the ArcGIS Pro documentation on database connections (specifically, the section on Microsoft Entra ID authentication options: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/database-connections-in-arcgis-pro.htm#...), we should be able to leverage Microsoft Entra authentication for this connection.
We are successfully able to connect to the SQL Server Managed Instance database via SQL Server Management Studio (SSMS) using the Microsoft Entra authentication options (e.g., Azure Active Directory - Universal with MFA, Azure Active Directory - Password).
Furthermore, we are able to successfully connect to the SQL Server database using database authentication (SQL Server Authentication) via ArcGIS Pro.
However, when attempting to connect to the same instance from ArcGIS Pro v3.5 using the same Microsoft Entra authentication method and credentials, we consistently receive the error: "Bad user login."
We have meticulously verified the username and password multiple times to ensure their correctness.
Any help from anyone will be highly appreciated.
Thank you,
Ayush
