# SQLServer Mirroring configuration, failover is not working

**URL:** <https://forum.keycloak.org/t/sqlserver-mirroring-configuration-failover-is-not-working/1643>\
**Category:** Configuring the server\
**Created:** [March 11, 2020, 8:50am UTC](https://forum.keycloak.org/t/sqlserver-mirroring-configuration-failover-is-not-working/1643 "2020-03-11T08:50:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![michelgerber](https://avatars.discourse-cdn.com/v4/letter/m/41988e/32.png) [@michelgerber](https://forum.keycloak.org/u/michelgerber)\
**Post date:** [March 11, 2020, 8:50am UTC](https://forum.keycloak.org/t/sqlserver-mirroring-configuration-failover-is-not-working/1643/1 "2020-03-11T08:50:03Z")

</div>

Hi,

I’m trying to configure Keycloak 9.0.0 with SQL Server (JDBC) and a failoverPartner in order to support high availability from the Database.

According to the JDBC documentation, I should only specify the failoverPartner in order to make it work.  
However once I failover the database to the mirror server, Keycloak cannot get the connection to the database. When I failover back to the original server, Keycloak is also unable to recreate the connection.  
My configuration is as following

 jdbc:sqlserver://192.168.122.32\mssql2;failoverPartner=192.168.122.31\mssql2;databaseName=keycloak;integratedSecurity=false;user=svc\_keycloak;password=xxxxxxxxxx sqlserver svc\_keycloak xxxxxxxxxx 

is there something I should add to make it work ?

Thank you for your support.