SQL Server Connection String - MultiSubnetFailover True or Yes?
2
votes
2
answers
14314
views
The MultiSubnetFailover option in database connection strings controls how the client attempts to connect to a database server, especially when multiple IPs are available.
There is conflicting documentation as to whether the correct connection string syntax is:
MultiSubnetFailover=Yes
https://learn.microsoft.com/en-us/sql/connect/oledb/features/oledb-driver-for-sql-server-support-for-high-availability-disaster-recovery?view=sql-server-ver16
Or:
MultiSubnetFailover=True
https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/sqlclient-support-for-high-availability-disaster-recovery
Are both "Yes" and "True" supported? Or does it vary by driver? If the latter, is there a list of which drivers support which syntax?
Update 2023-03-30:
This Microsoft documentation implies that "True" or "Yes" will work for another option:
> The default setting for the Persist Security Info keyword is false.
> Setting it to **true or yes** allows security-sensitive information,
> including the user ID and password, to be obtained from the connection
> after the connection has been opened. Keep Persist Security Info set
> to false to ensure that an untrusted source does not have access to
> sensitive connection string information.
https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/connection-string-syntax
(emphasis added)
Asked by Riley Major
(1965 rep)
Mar 30, 2023, 02:39 PM
Last activity: Mar 31, 2023, 04:43 AM
Last activity: Mar 31, 2023, 04:43 AM