Guest Operating Systems

 View Only

SQL multi subnet failover on Windows 2008 r2

  • 1.  SQL multi subnet failover on Windows 2008 r2

    Posted Apr 27, 2016 02:49 PM

    When I update my VMware tools to version 10.0.0 thought 8 Multi subnet failover for SQL 2014 stops working. I get a error using the .net connector

    connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.

    This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=21106; handshake=0;

    to recreate the issue

    from powershell

    $conn = New-Object -TypeName System.Data.SqlClient.SqlConnection

    $conn.ConnectionString = 'Data Source=SQLClusterName;Initial Catalog=Database;     User ID=username;Password=pass!;MultiSubnetFailover=True'

    $conn.Open()

    This issue does not occur on 2012r2. Rolling back to VMware tools 9.x fixes the issue. I did not see anything in the release notes indicating this would be an issue.

    Has anyone else seen this issue? have any thoughts on what may fix the issue?

    Update

    I have been able to Downgrade the server to 9.10.5 then have tools update to 10.0.6 on reboot and not have the issue return. not a fix, but at least a workaround