I have two SQL Server 2016 VMs in Azure. I am trying to connect these two sql server instances using External datasource. I can safely connect the two instances from my local pc, remotely. While querying using external table/data source, I am getting this:
i) I have used both RDBMS/SHARD_MAP_Manager
ii) Credential is valid credential
iii) I know, i can use Linked Servers, but i don't want it. As i am planning to move these databases to Sql Azure Db. External Table and datasource is not mandatory. You can suggest alternatives other than LinkedServers.
So i need a query or part of query that will work with both, Sql Server(Virtual/Physical server) and Sql Azure(Db as a Service)
Same query ran flawlessly on Sql Azure db.