Unable to complete login process due to delay in prelogin response while trying to access External Tables

Carlos Molina 1 Reputation point
2022-07-13T13:02:23.423+00:00

Hi,

I can access tables, but cannot access external tables. I am getting the following error message:

An error occurred while establishing connection to remote data source: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Timeout error [258]. [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired[Microsoft][ODBC Driver 17 for SQL Server]Unable to complete login process due to delay in prelogin response

This error happens while running a select on any of the external tables.

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. MITAL BHADANIYA 1 Reputation point
    2022-07-13T16:54:51.027+00:00

    Just would like to know if linked server has been establised correctly between two databases/servers.
    Refer this link to establish linked server. As you are getting ODBC error which means connectivity is not established correclty between two databases/servers.
    Hope this will resolve your issue.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.