# MSSQL failover and Ignition settings

**URL:** <https://forum.inductiveautomation.com/t/mssql-failover-and-ignition-settings/103190>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [March 4, 2025, 7:23am UTC](https://forum.inductiveautomation.com/t/mssql-failover-and-ignition-settings/103190 "2025-03-04T07:23:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matjaz\_Furlan](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Matjaz\_Furlan](https://forum.inductiveautomation.com/u/Matjaz_Furlan)\
**Post date:** [March 4, 2025, 7:23am UTC](https://forum.inductiveautomation.com/t/mssql-failover-and-ignition-settings/103190/1 "2025-03-04T07:23:07Z")

</div>

Hi all,

In our company we already establish MSSQL replication on failover. After MSSQL server is down, MSSQL automaticly transfer on different server. We tried and tested yesterday but JDBC driver cannot resolve this. I tried to add parameter:

> MultiSubnetFailover=True

in field Extra Connection Properties, but without success... Any ideas?  
Regards