This video provides a complete walkthrough of the configuration prerequisites, from creating an Application User in Dataverse to granting access in Azure SQL Database.
🎥 [VIDEO EMBED: Configuration Walkthrough]
Video length: Approximately 8 minutes
What You'll Learn
This video covers the complete setup process for connecting DvSchemaSync to your Dataverse and Azure SQL environments:
Creating an Application User in Dataverse — Navigate the Power Platform Admin Center, add a new Application User, and link it to your App Registration.
Assigning Security Roles — Select and assign appropriate security roles to control data access for your Application User.
Configuring Azure SQL for Entra Authentication — Set up Microsoft Entra admin on your SQL Server and configure authentication settings.
Granting Database Access to Your App Registration — Execute the SQL commands to create an external user and assign the db_owner role.
Testing Your Configuration — Verify that both Dataverse and Azure SQL connections work correctly in DvSchemaSync.
Video Chapters
0:00 — Introduction
0:45 — Creating an Application User in Power Platform Admin Center
3:15 — Assigning Security Roles to the Application User
5:00 — Configuring Microsoft Entra Admin on Azure SQL Server
7:30 — Running SQL Commands to Grant App Registration Access
9:45 — Testing Connections in DvSchemaSync
11:30 — Summary and Next Steps
Related Pages
• Page 1: Microsoft Entra App Registration
• Page 2: Dataverse Environment Setup
• Page 3: Azure SQL Database Setup
• Section 1, Page 1: Quick Start Guide