https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-with-azure-sql-managed-database-and/m-p/1672599#M43588 <P>Hi</P><P>We have an Enterprise 11.5 deployment connected to an Azure SQL Managed Database.</P><P>With the release of Pro3.6, we can now connect to the database from Pro using the Entra MFA authentication method, as the 31char username limit has been fixed.</P><P>What we cant do is register a datastore connection on ArcGIS Server, where the publisher connection is the MFA connection, and the server connection used DBMS auth.&nbsp; The connection registers just fine from either the server, or by creating it in Pro, but when you publish a service, it just eventually times out after 12 hours.&nbsp; there are notable errors in the server log, and the same service published fine to a data store connection which uses a DBMS-Published to DBMS-Server connection swizzle.</P><P>The job uploads and starts on the server, and the job logs just say its processing.</P><P>Anyone else doing this?&nbsp; Should this work (it seems like something which should!).&nbsp; There is a statement in some docs which says an MFA connection cant be used by a server, but we're not doing that, we are swizzling from a published MFA connection to a server DBMS conenction.</P><P>Thanks for any tips!</P> Fri, 12 Dec 2025 08:36:07 GMT AdamPigg 2025-12-12T08:36:07Z https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-with-azure-sql-managed-database-and/m-p/1672599#M43588 <P>Hi</P><P>We have an Enterprise 11.5 deployment connected to an Azure SQL Managed Database.</P><P>With the release of Pro3.6, we can now connect to the database from Pro using the Entra MFA authentication method, as the 31char username limit has been fixed.</P><P>What we cant do is register a datastore connection on ArcGIS Server, where the publisher connection is the MFA connection, and the server connection used DBMS auth.&nbsp; The connection registers just fine from either the server, or by creating it in Pro, but when you publish a service, it just eventually times out after 12 hours.&nbsp; there are notable errors in the server log, and the same service published fine to a data store connection which uses a DBMS-Published to DBMS-Server connection swizzle.</P><P>The job uploads and starts on the server, and the job logs just say its processing.</P><P>Anyone else doing this?&nbsp; Should this work (it seems like something which should!).&nbsp; There is a statement in some docs which says an MFA connection cant be used by a server, but we're not doing that, we are swizzling from a published MFA connection to a server DBMS conenction.</P><P>Thanks for any tips!</P> Fri, 12 Dec 2025 08:36:07 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-with-azure-sql-managed-database-and/m-p/1672599#M43588 AdamPigg 2025-12-12T08:36:07Z