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