Unable to connect to Azure SQL Managed Instance database with Microsoft Entra Authentication in ArcGIS Pro

Description

In ArcGIS Pro 3.5 and earlier, when forming a database connection to an Azure SQL Managed Instance (SQL Server) database, the following error message is returned:

Error:   
Bad login user

Cause

The database username exceeds the character limit for the 'User name' object type in the ArcGIS Pro database connection. For SQL Server, the username character limit must not exceed 31 characters. Refer to ArcGIS Pro: Name length for more information.

Solution or Workaround

Note:
Pre-requisites before attempting the workaround:
• Create and configure Azure SQL Managed Instance and the database in it. Refer to Microsoft Azure: Quickstart: Create Azure SQL Managed Instance for more information.
• Configure the public endpoint for Azure SQL Managed Instance. Refer to Microsoft: Configure public endpoints in Azure SQL Managed Instance for more information.
• Install the Microsoft ODBC driver for the SQL Server as an SQL client that runs on the ArcGIS Pro machine. Refer to ArcGIS Pro: Install the ODBC driver for SQL Server for SQL Server and ArcGIS Pro: Database and data warehouse clients for more information. 

1. Create short login names with passwords in SQL Server Management Studio (SSMS). Ensure the credentials are within the ArcGIS Pro character limit. Use this credential to connect the Azure SQL Managed Instance to ArcGIS Pro. Refer to Microsoft: Create a login for more information.
2. Connect to the Azure SQL Managed Instance database in ArcGIS Pro. Refer to ArcGIS Pro: Connect to the database for more information.

Optionally, update ArcGIS Pro to version 3.6 or later. Refer to ArcGIS Pro: Update ArcGIS Pro for more information.