idea ArcGIS for Desktop support to handle SQL Server availability group failovers in Data Management Ideas https://community.esri.com/t5/data-management-ideas/arcgis-for-desktop-support-to-handle-sql-server/idi-p/925677 <P>It's possible to create a read only connection using ArcCatalog or to simply connect to an availability group listener, however if an availability group fail over happens the connection gets disconnected and you have to establish a new connection. &nbsp;It would be nice to have a "re-try or auto-reconnect" step happen before the connection is terminated. &nbsp;This would help maintain the connection and gracefully handle an availability group&nbsp;fail over.</P> Wed, 05 Oct 2022 23:21:47 GMT RyanSadler 2022-10-05T23:21:47Z ArcGIS for Desktop support to handle SQL Server availability group failovers https://community.esri.com/t5/data-management-ideas/arcgis-for-desktop-support-to-handle-sql-server/idi-p/925677 <P>It's possible to create a read only connection using ArcCatalog or to simply connect to an availability group listener, however if an availability group fail over happens the connection gets disconnected and you have to establish a new connection. &nbsp;It would be nice to have a "re-try or auto-reconnect" step happen before the connection is terminated. &nbsp;This would help maintain the connection and gracefully handle an availability group&nbsp;fail over.</P> Wed, 05 Oct 2022 23:21:47 GMT https://community.esri.com/t5/data-management-ideas/arcgis-for-desktop-support-to-handle-sql-server/idi-p/925677 RyanSadler 2022-10-05T23:21:47Z Re: ArcGIS for Desktop support to handle SQL Server availability group failovers https://community.esri.com/t5/data-management-ideas/arcgis-for-desktop-support-to-handle-sql-server/idc-p/925678#M519 <HTML><HEAD></HEAD><BODY><P>This would be a great addition! &nbsp;I've ran into this issue recently too, and have to close my session and reconnect.</P></BODY></HTML> Wed, 14 Dec 2016 21:22:19 GMT https://community.esri.com/t5/data-management-ideas/arcgis-for-desktop-support-to-handle-sql-server/idc-p/925678#M519 MichaelDuncan7 2016-12-14T21:22:19Z