Power Platform Community Forum Thread Details

Hi All,

Getting below error while i am trying to connection with SQL server of Dynamic CRM on premised with windows authentication in NON production or production gateway. Do i need to open any specific port? Need urgent help.

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=18; handshake=29992; inner exception: 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=18; handshake=29992; clientRequestId: f8370098-ab69-4fee-b181-87ae1de80e4e

Thank you in Advance.

Categories:

Using connectors