MATLAB: How to enable MultiSubnetFailover when using the Database Toolbox for connecting to a SQL Server with high availability

Database Toolbox

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

Best Answer

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
Related Question