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

Hello,

 

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:

 

jdbc:clarity:sqlserver://SERVERMASTER:1433;DatabaseName=niku;failoverPartner=SERVERSLAVE;InsensitiveResultSetBufferSize=0;ProgramName=Clarity

 

But I don´t think it is working.

 

Thanks,

 

Roberto Barra

Outcomes