Forum Discussion
Pre-login Handshake Error
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.
It might be that Synapse access controls are preventing your specific IP address from connecting:
4 Replies
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.
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=11It might be that Synapse access controls are preventing your specific IP address from connecting: