droordaEPG
Contributor
Contributor

SQL multi subnet failover on Windows 2008 r2

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

0 Kudos
0 Replies