MSSql Connection with Failover

Grafana MSSQL
1

Hi Community,
is it possible to add a database connection to mssql Server which is configured using failover cluster? So my regular connection string looks like:
Data Source=ServerA,1440;Failover Partner=ServerB,1440;
This doesnt seem to work with the current connection setup.

Any help appreciated
Thank you very much folks and best regards
Marco

2

Create a VIP (Virtual IP) in your network where config MSSQL Active.

3

Hi Alexandrefrp,

thank you for your response. Do you have any more details on how to setup configuration for a virtual ip?

Thanks and best regards
Marco