Error: “Connection Timeout Expired” in the Instance Details Pane with DxAdmin

Applies to…

  • DxEnterprise 15.5 and newer for Windows

Summary

An error of “Connection Timeout Expired” is seen in the instance details pane when selecting the instance in DxAdmin.

Information

In some versions of Microsoft Windows Server, notably in Windows Server 2016 CTP4 and above, connections to a SQL Server instance running on the same node as the client can fail to complete if the Vhost cannot be resolved by name.

This can cause the following issue in the Instance Detail pane within DxAdmin:

:         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=<#>; handshake=<#>;

Solution

Ensure that all nodes are able to resolve all Vhosts. This can be done using DNS (preferred) or HOSTS file entries on each node.