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