How do I enable MultiSubnetFailover when using the Database Toolbox for connecting to a SQL Server with high availability?
5 次查看(过去 30 天)
显示 更早的评论
MathWorks Support Team
2017-6-19
编辑: MathWorks Support Team
2021-3-9
How do I enable MultiSubnetFailover when using the Database Toolbox for connecting to a SQL Server with high availability?
采纳的回答
MathWorks Support Team
2021-3-9
编辑: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 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!