Linked Service to Azure SQL DB Using Managed Identity
Вставка
- Опубліковано 19 сер 2024
- Learn more: • Azure Data Factory Tut...
🔗 Azure Data Factory Tutorial 2 | Creating Linked Services to Azure SQL DB Using Managed Identity 🔗
Azure Data Factory Tutorial 1 | Introduction:
• Get started with Azure...
Azure Managed Identities Explained:
• How to use System & Us...
Are you ready to take your Azure Data Factory skills to the next level? 🚀 In this tutorial, we'll walk you through the process of creating a Linked Service from Azure Data Factory to an Azure SQL Database using the system-assigned managed identity feature. This powerful technique enhances security and simplifies authentication, making your data integration workflows smoother than ever.
🎯 What you'll learn in this tutorial:
🔹 Managed Identity Benefits: Discover the advantages of using Data Factory's system-assigned managed identity for secure and hassle-free authentication.
🔹 Step-by-Step Guide: We'll break down the process into easy-to-follow steps, guiding you through each configuration required to establish the connection between Azure Data Factory and Azure SQL Database.
🔹 Real-time Demonstration: Witness a live walkthrough in the Azure portal as we set up the Linked Service and leverage the system-assigned managed identity.
💡 By the end of this tutorial, you'll have a solid understanding of how to create a Linked Service with a system-assigned managed identity, enhancing your data integration capabilities and improving your workflow efficiency.
📢 Ready to elevate your Azure Data Factory game? Don't forget to give us a thumbs up 👍 if you find this tutorial helpful. For more insightful content on Azure services, data integration, and cloud computing, hit that 🔔 Subscribe button and enable notifications. Have questions or want us to cover specific topics in future videos? Feel free to drop your suggestions in the comments below.
🔗 Link to the material used in the demos
drive.google.c...
#AzureDataFactory #LinkedServices #ManagedIdentity #AzureSQLDatabase #DataIntegration #Tutorial #CloudComputing
What an awesome tutorial series. Definitely the best I've found so far.
Thank you, Aleksi! Keep churning the good stuff!
Awesome, thank you!
after searching a couple hours for a solution to build a working authentification to the sql databse, i finally found your video! thanks!
Very glad it helped! Using managed identity is one of the best and most secure ways of building this linked service.
Thanks for providing concise explanations with practical labs, which are excellent for beginners like me.
Glad it was helpful!
thank you a lot , i've had this problem for 2 days !
Glad it helped
Thanks very much for this tuto
You are welcome!
Thanks u very much for this video
Welcome!
Hi @Aleksi , i have followed all steps in this lecture. It does not work for me
Hmm it should work and hard to say what is wrong with your setup. I would double check that everything was done according to the video
I do not get the option Azure Active Directory - Universal with MFA besides the Authentication dropdown. Any ideas on how to access it? :(
I assume that your problem is with SQL Server Management Studio? Only tip that comes in mind is that you should make sure that you are not using some very old version of SQL Server Management Studio.
bro i run this sql query but "Cannot alter the role 'db_owner', because it does not exist or you do not have permission." as error i saw in your videos you didnt have db onwer databse but i stuck i have project to done and it will help me to clear my assignment for getting job please help me in this
Hmm probably you don’t have sufficient access rights to that database to be able to grant db_owner to Data Factory
@@AleksiPartanenTech what I can do