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

5 次查看(过去 30 天)

采纳的回答

MathWorks Support Team
编辑:MathWorks Support Team 2021-3-9
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:

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

标签

尚未输入任何标签。

产品


版本

R2016b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by