This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 54%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Hi,
Is it possible to create an external data source connection from an Azure SQL Database to SQL server running on an Azure VM.
I've created the connection to external server (Azure VM) which creates but when I try to query it, it fails
CREATE EXTERNAL DATA SOURCE ServerName
WITH
(
TYPE=RDBMS,
LOCATION='ServerName',
DATABASE_NAME='DatabaseName',
CREDENTIAL=Credential
);
Msg 46832, Level 16, State 3, Procedure sp_execute_remote, Line 1 [Batch Start Line 0]
An error occurred while establishing connection to remote data source: [Microsoft][ODBC Driver 17 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53]. [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired[Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
I can connect to the SQL Instance on the Azure VM from my laptop via SSMS, so remote connections are enabled.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi Matt Brooks •
Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.
Also, we recommend you to raise feedback over Azure SQL Database Feedback Channel if you want the feature to be implemented by the concerned team. They will work on it depending on the importance and up-votes.
Thank you.
It is not supported. Elastic database queries (the creation of external data sources) work between Azure SQL Databases only.
Please consider replicating the tables you need from Azure SQL to SQL Server using Azure SQL Data Sync.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 15%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Hi @Alberto Morillo when you say it works between Azure SQL Databases only, can I consider Azure SQL MI as well?
My requirement is to create external data source from Azure SQL DB to Azure SQL MI.