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.
Unable to complete login process due to delay in prelogin response while trying to access External Tables
Carlos Molina
1
Reputation point
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.
1 answer
Sort by: Most helpful
-
MITAL BHADANIYA 1 Reputation point
2022-07-13T16:54:51.027+00:00