Share via

Excel Power Query Timeout Error. Pre-Login Handshake Failed

Anonymous
2017-05-24T13:31:05+00:00

Please see the attached snips from excel. I am trying to connect to a database via "New Query" in excel and received an error. Please note, I can access this database using SQL.

Snip 1:

Snip 2:

Snip 3:

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2017-05-24T15:15:40+00:00

    Hi John,

    Based on my research, the issue is caused by SQL settings. You may need to change the SQL settings not the Excel client. You can try changing the CommandTimeoutproperty of your SqlCommand object. The Connect Timeoutattribute of a connection string determines how long a SqlConnection Object runs before it stops attempting to connect to a server. The CommandTimeout should set to 0.

    Moreover, since the question is mainly related to SQL not the Excel client, we suggest you post a new thread in Microsoft SQL server forum for professional support. It’s the specific channel that handles SQL related questions.

    Thanks for your understanding.

    Rodney

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest