NEW6.00.00 · Released 17 April 2025
High Importance
NEWfinPOWER Connect
Released in
6.00.00
17 April 2025
  1. Opened9 Dec 2019
  2. Closed14 Oct 2024
  3. Released17 Apr
Article 22131 Job J023427

SQL Server Databases; new options to set "MultiSubnetFailover" and "ApplicationIntent" connection string properties

New options have been added for SQL Server and Azure SQL databases to set "MultiSubnetFailover" and "ApplicationIntent" Connection String properties.

When opening a database, for example, you may specific the follow options under a new heading "High Availability":

  • Enable Multi Subnet Failover?
    • Adds ";MultiSubnetFailover=Yes" to the Connection String
    • Note, the default is "ReadWrite"
  • Application Intent is Read Only?
    • Adds ";ApplicationIntent=ReadOnly" to the Connection String
    • Note, the default is "No"

The new options are stored in the Intersoft Connection string, for example:

[SQLSERVER]finPOWERConnect_finDemo_Reporting@Server;Encrypt=Yes;MultiSubnetFailover=Yes;ApplicationIntent=ReadOnly

The change affects the following areas:

  • Database Open
    • Including ISCommonDialog.GetDatabase function.
      • Used in Global Settings, Reporting Database
  • Database Compare
  • Database Configuration File Builder
  • Database Copy
  • Database Document
  • Database Index Rebuild
  • Database Reset Permissions
  • Database Upgrade
  • Database Update Unicode