External table creation based on table from another server

Gowri Shankar 211 Reputation points
2021-08-16T13:20:42.01+00:00

Hi,

I am trying to create an External table in one database server , by accessing some table from another Remote Database server.

Creation of External Data source as well as External table was successful. But when I try to query the External Table, it is giving me the below error:

Error Message:
Msg 46824, Level 16, State 1, Line 1
Login failed on remoteserver.windows.net.DB_name. Please verify that the shards are accessible and that the credential information affiliated with external data source testExtDtaSource is correct.

Can you please confirm whether it is possible to create External table and get the data in one database server from another remote server ?

Attached is the script used for creating external table.123636-script-used.txt

Kind Regards,
Gowri Shankar

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

1 answer

Sort by: Oldest
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

Your answer

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