Post reply

availability group multi subnet failover

  • September 27, 2016 at 7:23 am

    #313942

    I have read that OLEDB connection managers SQL 2012 SSIS do not support multisubnetfailover=true properties and it you have to use ADO.net.

    Can someone confirm that in SQL 2014 this is supported? I have created a package and put the property in Extended Properties and it hasnt errored, but i just want to clarify if i need to change all my connection managers or not??

  • September 27, 2016 at 7:38 am

    #1903336

    It's an option for the version 11 and 13 ODBC driver

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

  • September 27, 2016 at 7:43 am

    #1903337

    It seems to be working, i have failed it over a few times between different data centers using OLEDB with multisubnetfailover=true without issues.....

    I think the article i read is bullsh1t

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply