Connect to SQL Database Issue in Studio

[Sisay_Dinku (Sisay YDG)]

Hi team,

When I try to connect to SQL DB, I receive the following error message.

Connect to database: 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=19117; handshake=13043;

Connection:

Error Message:

Is there any configuration needed? If so, what would be your suggestions? Thanks a lot for your help!

Best regards,
Sisay

[Palaniyappan (Forum Leader)]

Increase the Timeout property around 60000 milliseconds or more that that and give a try

Make sure you have the latest version of database activity package

Check this out

The timeout period elapsed prior to completion of the operation or the server is not responding

i always get error Run query: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. when in Run Query Activity. I already add connect timeout but still received this error. here is my connection string. Data Source=Server1;Initial Catalog=SampleDb;Integrated Security=True;Connect Timeout=1000000;Encrypt=False

Cheers @Sisay_Dinku

[Sisay_Dinku (Sisay YDG)]

Hi @Palaniyappan

That’s very helpful. It is now connecting, and I am able to extract data from the DB’s tables.
Appreciate the help!