ADFS - SQL AlwaysOn Availability Groups and multisubnetfailover

Question

I am currently implementing a highly available AD FS solution. We are using SQL AlwaysOn Availability Groups between data centres. I have been asked why we aren't using the multisubnetfailover=true in the data source connection string. I have looked at the Microsoft documentation for implementing AD FS with AlwaysOn Availability Groups and the data source strings do not specify, or even mention, multisubnetfailover=true in the string. 

My question is does AD FS support the multisubnetfailover=true in the data source string. I have tested this connecting to a standalone SQL instance and AD FS was still able to connect to it. If this is so important why isn't it included in the Microsoft documentation for AD FS using SQL AlwayOn Availability Groups.

What will be the effect of not using this option if it is supported ? Without someone has stated the AD FS solution will be unstable. Is this correct? 

Any help is gratefully appreciated.

Stuart

Answer 1

Hi Stuart,

Yes, AD FS supports the multisubnetfailover=trueparameter. We may encounter connection issues to the database if not using this option. So, I suggest you add it in the configuration.

Regards,

Larry

Answer 2

Hi Stuart,

Does the answer address your concern?

Regards,

Larry