All Collections
Inspectors
Microsoft SQL Server
Microsoft SQL Server | Troubleshooting "Connection Timeout Expired"
Microsoft SQL Server | Troubleshooting "Connection Timeout Expired"
Updated over a week ago

Error: Connection Timeout Expired

Connectivity test failed. Exception: 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=12345; handshake=12345;\`


This setup issue could indicate a range of issues, here are a few of the most common areas to check:
​
​TCP/IP
​
Verify that TCP/IP is enabled for both IPv4 and IPv6 addresses for your instance under SQL Server Network Configuration in SQL Server Configuration Manager. It's also worth checking to see if inbound connections for the TCP/IP port, the SQL Server Database Engine, is listening or [might be blocked by your firewall](https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver15).
​
You should also double-check that the hostname and instance specified in the Inspector configuration template are correct for the instance you wish to inspect.

Did this answer your question?