question

SAURABHSHARMA-8310 avatar image
0 Votes"
SAURABHSHARMA-8310 asked PRADEEPCHEEKATLA-MSFT commented

Not able to connect Linked Service with Azure SQL

Connection failed
{"_body":null,"status":400,"ok":false,"statusText":"Bad Request","headers":{"_headers":{},"_normalizedNames":{}},"url":"https://dpcentralindia.svc.datafactory.azure.com/dataplane/subscriptions/13d43aaf-bd73-4f7e-b666-509ce783af0a/resourcegroups/DatafactoryDemo1/providers/Microsoft.DataFactory/factories/DatafactoryDemoV1985/testConnectivity?api-version=2018-06-01"}. Activity ID: f244f58f-5317-4a45-aefd-03c3eb5aae60

azure-data-factory
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @SAURABHSHARMA-8310,

Welcome to the Microsoft Q&A platform.

Could you please share below details investigate more.

  • Exactly at what step you are getting above error?

  • Kindly check is linked service test connection is getting success ? If not, kindly share screenshot of error message.

  • Open your Azure SQL Database firewall setting and make sure your enable to setting to allow other azure services to access your DB.

0 Votes 0 ·

Hi,

Thanks for your revert.

1)Created a linked service where it tried connecting to Azure SQL Database and while using that service with test connection option,I am getting the above mentioned error which I have pasted in Chat,



0 Votes 0 ·

Please find the screenshot of the error message:

104783-error-microsoft.jpg


0 Votes 0 ·
error-microsoft.jpg (56.9 KiB)

Hello @SAURABHSHARMA-8310,

Thanks for the details.

Are you able to connect to any other linked service connection other than Azure SQL Database?

0 Votes 0 ·

Hello @SAURABHSHARMA-8310,

Follow up to see if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.

0 Votes 0 ·

0 Answers