If I want to add MultiSubnetFailover=True as part of the SQL Server connection string, how do I do that? I'm working in a high-availability scenario, and while I can see a ApplicationIntent property for TMSConnection, I don't see a property for MultiSubnetFailover. For reference purposes - https://msdn.microsoft.com/en-us/librar ... .110).aspx
Thanks in advance.
MultiSubnetFailover
Re: MultiSubnetFailover
SDAC doesn't support the MultiSubnetFailover option, since we use OLEDB or NativeClient when working with SQL Server, and they don't support this option: http://msdn.microsoft.com/en-us/library/gg471494.aspx
Re: MultiSubnetFailover
Thanks for the clarification.
Re: MultiSubnetFailover
If you have any questions while using our products, please don't hesitate to contact us - and we will try to help you resolve them.
Re: MultiSubnetFailover
Hi,
Based on the following link from Microsoft, Native Client 2012 is able to support "Always On" feature.
https://docs.microsoft.com/en-us/sql/re ... r-recovery
Can you please specify the properties that needs to be done on SDAC?
Thanks
Based on the following link from Microsoft, Native Client 2012 is able to support "Always On" feature.
https://docs.microsoft.com/en-us/sql/re ... r-recovery
Can you please specify the properties that needs to be done on SDAC?
Thanks
Re: MultiSubnetFailover
Unfortunately, SDAC does not support the MultiSubnetFailover parameter, as we use OLEDB when working with NativeClient.
OLE DB in the SQL Server Native Client does not support the MultiSubnetFailover keyword.
OLE DB in the SQL Server Native Client does not support the MultiSubnetFailover keyword.