FSMO Roles in Active Directory

Connection Timeouts When Using Multisubnetfailover=True

When you try to connect to Microsoft SQL Server 2012 through an AlwaysOn availability group listener from a client application, you may experience a logon time-out error message.

Connection Timeouts When Using Multisubnetfailover=True

This issue occurs because the Tdx.sys driver does not handle the Closesocket() function correctly when the function is called in the middle of a TCP/IP handshake.

After installing the below hotfix . I am able to connect to SQL database using “multisubnetfailover=true” without any issue.

http://support.microsoft.com/hotfix/kbhotfix?kbnum=2870437&kbln=en-us