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