Azure Sql Database - Elastic Query To Azure Vm Sql Instance - Ssl Error

I need to connect from an Azure SQL Database to an Azure VM that has a SQL Server instance installed. Since linked servers are not supported by Azure SQL Databases, I went with the

Solution 1:

Re the exception on your query: Based on the error message, this looks like the SQL Server on your VM does not have a CA signed certificate installed. Elastic query enforces encryption on its connections and it sets Trust Server Certificate to false. Installing a CA signed certificate should fix that issue from what I can tell by looking at the error.

Re network traffic: Both the VM and the Azure SQLDB database are created in a particular region. If you choose to create them in the same region, then the network traffic will be internal to the data center. If you create them in different regions, you will incur cost for cross-data center traffic.

Hope this helps.

Thanks, Torsten