Linked Service to Azure SQL DB Using Managed Identity

🔥 *Learn Microsoft Fabric hands-on!* 👉 https://www.skool.com/fabricforge 🔥 *Ace Your Certification Exams – Free Practice Questions!* 👉 https://certiace.com/ ☕ *Enjoying the Content? Support the Channel!* 💖 https://buymeacoffee.com/aleksipartanentech 👨‍💼 *Follow Me on LinkedIn!* 🔗 https://www.linkedin.com/in/aleksi-partanen/ 🚨 *Join the Free Microsoft Fabric Community on Discord!* 👉 https://discord.gg/33BR22bcHH 📚 *Recommended courses on Datacamp:* Python Data Fundamentals: https://datacamp.pxf.io/c/6429510/3120208/13294 Data Analyst in Python: https://datacamp.pxf.io/c/6429510/3120142/13294 SQL Fundamentals: https://datacamp.pxf.io/c/6429510/3120137/13294 Power BI Fundamentals: https://datacamp.pxf.io/c/6429510/2917378/13294 PL-300: Microsoft Power BI Data Analyst: https://datacamp.pxf.io/c/6429510/3120133/13294 Data analyst in Power BI: https://datacamp.pxf.io/c/6429510/3120130/13294 More courses: https://datacamp.pxf.io/c/6429510/2073461/13294 These are affiliate links. If you sign up through them, I may earn a small commission at no extra cost to you. Thanks for supporting the channel. 📂 *Access Learning Materials (Files, Code, etc.)* 💾 Download helpful resources here: 🔗 https://drive.google.com/drive/folders/137oJUhjRJhZZsnRln8tlJBcl1OYc2X2C?usp=sharing 🎓 *More of My Content:* 🎥 https://www.youtube.com/playlist?list=PLlqsZd11LpUES4AJG953GJWnqUksQf8x2 🎥 https://www.youtube.com/playlist?list=PLlqsZd11LpUHKLILXjfW5ORjNiksC3GWZ 🎥 https://www.youtube.com/playlist?list=PLlqsZd11LpUEq26ZswRz58k5O5HwoSDvA 🎥 https://www.youtube.com/playlist?list=PLlqsZd11LpUGsj71luXuOhk78fF0frscd 🎥 https://youtu.be/0PjuNHYiX00 🎥 https://youtu.be/1PGE9bWqY2g 🎥 https://youtu.be/qoVhkiU_XGc 🔗 All the Videos: https://www.youtube.com/@AleksiPartanenTech/videos How to Create a Linked Service from Azure Data Factory to Azure SQL Database Using System-Assigned Managed Identity Welcome back to the channel! In this Part 2 of the Azure Data Factory series, Aleksi walks you through the process of creating a linked service from Azure Data Factory to an Azure SQL Database using system-assigned managed identity. If you’re not familiar with managed identities, don’t worry—there’s a dedicated video explaining the concept, linked in the description! What You’ll Learn in This Video: 🔹 The basics of how Azure Data Factory connects to Azure SQL Database. 🔹 Configuring the SQL Server firewall to allow connections. 🔹 Creating a database user for Data Factory and assigning roles using T-SQL. 🔹 Establishing the linked service in Data Factory with system-assigned managed identity. Key Takeaways: ✅ Understand the importance of SQL Server firewall configurations. ✅ Learn to use managed identities for secure and seamless authentication. ✅ Follow best practices when assigning roles to database users. ✅ Test and validate your connection between Data Factory and SQL Database. Steps in the Video: SQL Database Setup: Create an Azure SQL Database and SQL Server. Configure SQL Server firewall rules for both your IP and Azure resources. Database User Creation: Use SSMS to create a database user for Data Factory via T-SQL. Assign appropriate roles (e.g., DB Owner) to the user. Linked Service in Data Factory: Open Azure Data Factory and configure a new linked service. Use system-assigned managed identity for authentication. Test and verify the connection. Related Hashtags: #AzureDataFactory #AzureSQLDatabase #ManagedIdentity #DataIntegration #AzureTutorials