How do I enable MultiSubnetFailover when using the Database Toolbox for connecting to a SQL Server with high availability?

How do I enable MultiSubnetFailover when using the Database Toolbox for connecting to a SQL Server with high availability?

Answer 1

[MathWorks Support Team]

By default when you try to connect to a SQL server database using 'database' command 'multiSubnetFailover' is set to 'false'. However, you can overwrite this value by using using 5 argument style syntax for the 'database' command, where you provide 'multiSubnetFailover' as property name and set it to true.

Please refer to following link to read more about 'database' command and it's parameters:

http://www.mathworks.com/help/releases/R2016b/database/ug/database.html

For example you can try using following command to enable 'multiSubnetFailover':

database('data_source','username','password','com.microsoft.sqlserver.jdbc.SQLServerDriver','jdbc:sqlserver://server:port;database=databasename; multiSubnetFailover=true;')

Please make sure that you have completed these pre-configuration steps before you try to use Windows authentication to connect to SQL Server:

https://www.mathworks.com/help/database/ug/microsoft-sql-server-jdbc-windows.html