Azure SQL Database
An Azure relational database service.
6,107 questions
Not able to connect to the Destination from Azure Blob to Azure SQL Database
![](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(153.6, 60%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Marina Li
6
Reputation points
22300
Troubleshooting guide
Details
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'servername-ml.database.windows.net', Database: 'databasename', User: 'gmarinali@réalisations .co.uk'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
Cannot open server "yahoo.co.uk" requested by the login. The login failed., SqlErrorNumber=40532,Class=20,State=1,
Activity ID: e898fbaf-0781-4fae-899f-617bb8c400c4.
{count} vote
-
GeethaThatipatri-MSFT 29,527 Reputation points Microsoft Employee2022-10-02T23:02:16.137+00:00 Hi, @Marina Li Welcome to the Microsoft Q&A Platform, and thanks for your query.
Can you please share the steps you followed to connect and a screenshot of the error? to better assist you.Regards
Geetha -
![](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(35.2, 66%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
JONATHAN LEWIS 0 Reputation points2023-02-19T05:54:17.0533333+00:00 I'm getting the same thing when i try to test my connection for my linked service I'm trying to create in my ADF package
I looked at my firewalls and added the needed rules please see below:
Please let me know any suggestions that come to mind, I am following Adam Marczak ETL tutorial - https://youtu.be/EpDkxTHAhOs
-
JONATHAN LEWIS 0 Reputation points
2023-02-19T05:56:00.8433333+00:00 - @Mariana Li you ever get this worked out??
Sign in to comment
Sign in to answer