Roberto Barra - Ágila

SQLServer Failover Cluster

Discussion created by Roberto Barra - Ágila on Sep 24, 2014
Latest reply on Oct 1, 2014 by Chris_Hackett



Can Clarity handle more than one SQLServer working in an Failover Cluster configuration?


I am working with a Clarity that is using an SQL Server with this configuration. There are two SQL Server nodes (two SQL Servers): a master server and a failover server. Clarity database connection  is configured to talk to the master node. But I need to configure the failover node, so that the jdbc driver can switch to the failover server when the master stops responding. I´m looking for a solution similar to the jdbc url to handle oracle RACs.


This is the jdcb url that I'm testing:




But I don´t think it is working.




Roberto Barra