Create Azure Data factory Linked service to SQL Managed Instance

Question

Hi
I want to store data in a SQL managed instance database using azure data factory in this case, I have to create a linked service to this database but I get an error and I don't know how to go through

Answer 1

Hello @73836907,

Thanks for the question and using MS Q&A platform.

If you are passing the Fully qualified domain name as the Host provided in the Azure SQL Managed Instance overview page:

Error message: You will experience the same error message as shown above:

If you are passing the Fully qualified domain name as the public endpoint shown in networking page:

It will work as excepted.

Note: In case, if you want to use the private endpoint. You can create a managed private endpoint.

For more details, refer to Tutorial: How to access SQL Managed Instance from Data Factory Managed VNET using Private Endpoint

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

Hi

I resolved my problem by creating a managed endpoint network in Data Factory

https://learn.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-portal-private#create-a-managed-private-endpoint

thanks to all of you for your help