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(252.8, 95%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Have issues connecting a linked service on Synapse studio to Azure SQL DB.
I have another ADF on a different resource group which connects to the below Azure SQL DB with the same credentials and machine. But when I try to connect using synapse studio - linked service throws the below error.
Cannot connect to
SQL Database: 'sample-sql.database.windows.net',
Database: 'sample-db',
User: 'user'.
Check the linked service configuration is correct,
and make sure the SQL Database firewall allows the integration runtime to access.
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible.
Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: TCP Provider, error: 0 - No such host is known.), SqlErrorNumber=11001,Class=20,State=0,
No such host is known Activity ID: 3684f064-2a5c-4fc4-8eba-867aa64f231c.
Hello @Venkat Bommavaram ,
Thanks for the question and using MS Q&A platform.
When you say "I have another ADF on a different resource group which connects to the below Azure SQL DB with the same credentials and machine.", have you verified the SQL Database firewall allows the integration runtime to access?
For more detail, refer to Copy and transform data in Azure SQL Database by using Azure Data Factory or Azure Synapse Analytics and Connections from inside Azure.
Hi PRADEEPCHEEKATLA-MSFT,
Yes, using ADF we are able to extract the data from the Azure SQL DB. So that confirms the SQL Database firewall allows the integration runtime to access. Also, just to make sure we have everything for test we included firewall rule for IP 0.0.0.0 - 0.0.0.0, Client IP and my local IP.
Hello @Venkat Bommavaram ,
Could you please share the both screenshots of the linked service used in ADF and Synapse?
Hello @Venkat Bommavaram ,
Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.
Hey Pradeep,
I was able to resolve the issue. I just had to create a managed private end point and I was able to connect successfully.
Thanks!
Hello @Venkat Bommavaram ,
Glad to know that your issue has resolved. You can accept it as answer(
). This can be beneficial to other community members. Thank you.
![](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, 68%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
I faced same issue. I created Azure sql db and was getting same error connecting it in Azure Synapse studio.
I followed
https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure#connections-from-inside-azure
Section : Connections from inside Azure
When an application from Azure tries to connect to the server, the firewall checks that Azure connections are allowed by verifying this firewall rule exists. This can be turned on directly from the Azure portal blade by switching the Allow Azure Services and resources to access this server to ON in the Firewalls and virtual networks settings