Pre-login Handshake Error

[Anonymous]

Hello guys! Hoping you can help me with this error. 

Error Message:
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=584; handshake=14415; ;The wait operation timed out. The exception was raised by the IDbConnection interface.

[otravers]

Sounds like an error while trying to connect to a SQL server? You'll have to provide more details about the context in which this happens, preferably with screenshots.

[Anonymous]

The context behind is that, I have to load the data table from Azure Synapse.

What's weird is that all of my other colleague was able to do so except me. Appreciate your help on this

[otravers · Accepted solution]

It might be that Synapse access controls are preventing your specific IP address from connecting:

https://docs.microsoft.com/en-us/azure/azure-sql/database/network-access-controls-overview?view=azur...

[Anonymous]

This is the entire error

DataSource.Error: Microsoft SQL: 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=610; handshake=29390;
Details:
DataSourceKind=SQL
DataSourcePath=xxx
Message=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=610; handshake=29390;
ErrorCode=-2146232060
Number=-2
Class=11