0

We have multiple databases on the same server (running in the same Azure region as ADF). I would like to parameterize the database name in the connection.

When trying to follow along to this tutorial to connect to Azure SQL Database, I am unable to successfully connection to database when introducing dynamic content via a parameter. Connection test works if I remove the param and put the database name string in its place.

Note, the Azure SQL Database firewall is set to true for Allow Azure services and resources to access this server. Also using the AutoResolve IR.

Any ideas why this is not working?

Error Received:

enter image description here

Parameter Setup:

enter image description here

Improve this question

1 Answer 1

Reset to default
1

Due to you can connect successfully by hardcode, there is something wrong with Parameterize in Linked Service.

Please make sure the VALUE of dbname is same with your the value of hardcode.

enter image description here

Then change @linkedService().dbname to @{linkedService().dbname} and refresh your page to have a try.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.