Sample Header Ad - 728x90

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