ECN-GL557 Multi-subnet clustering support

Product: Acu4GL

Module: MSSQL

Machines Affected: Windows

DESCRIPTION:

Acu4GL now supports connecting to a Microsoft SQL Server running a multi-subnet failover cluster. To use this feature requires changes to the connection string sent to the server, which is accomplished by using the following 4 new configuration variables:

  • A_MSSQL_MULTI_SUBNET_FAILOVER - set to TRUE to enable a connection that supports multi-subnet failover support. If set to FALSE (the default) support is not enabled, and the other configuration variables have no effect.
  • A_MSSQL_FAILOVER_PARTNER - the name of the failover partner used. Refer to your SQL Server documentation for valid values.
  • A_MSSQL_FAILOVER_PARTNER_SPN - the name of the failover partner SPN used. Refer to your SQL Server documentation for valid values.
  • A_MSSQL_SERVER_SPN - the name of the Server SPN. Refer to your SQL Server documentation for valid values.