Use Self Hosted IR with Managed Identity for Azure SQL Database in Azure Data Factory | ADF Tutorial

Use Self Hosted IR with Managed Identity for Azure SQL Database in Azure Data Factory | ADF Tutorial | ADF Tutorial 2022, in this video we are going to learn Use Self Hosted IR with Managed Identity for Azure SQL Database in Azure Data Factory | ADF Tutorial | ADF Tutorial 2022, Azure Data Factory Step by Step - ADF Tutorial 2022 - ADF Tutorial 2022 Step by Step ADF Tutorial - Azure Data Factory Tutorial 2022.

CREATE USER [Techbrothersadf] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [Techbrothersadf];
ALTER ROLE db_datawriter ADD MEMBER [Techbrothersadf];

CREATE LOGIN [{your managed identity name}] FROM EXTERNAL PROVIDER
ALTER SERVER ROLE [db_owner] ADD MEMBER [Techbrothersadf]
ALTER SERVER ROLE [securityadmin] ADD MEMBER [{your managed identity name}]

Script:
Document used for reference
System-assigned managed identity authentication
A data factory or Synapse workspace can be associated with a system-assigned managed identity for Azure resources that represents the service when authenticating to other resources in Azure. You can use this managed identity for Azure SQL Database authentication. The designated factory or Synapse workspace can access and copy data from or to your database by using this identity.

To use system-assigned managed identity authentication, follow these steps.

Provision an Azure Active Directory administrator for your server on the Azure portal if you haven't already done so. The Azure AD administrator can be an Azure AD user or an Azure AD group. If you grant the group with managed identity an admin role, skip steps 3 and 4. The administrator has full access to the database.

Create contained database users for the managed identity. Connect to the database from or to which you want to copy data by using tools like SQL Server Management Studio, with an Azure AD identity that has at least ALTER ANY USER permission. Run the following T-SQL:

SQL

Copy
CREATE USER [your_resource_name] FROM EXTERNAL PROVIDER;
Grant the managed identity needed permissions as you normally do for SQL users and others. Run the following code. For more options, see this document.

SQL

Copy
ALTER ROLE [role name] ADD MEMBER [your_resource_name];

Azure Data Factory Tutorial for beginners
Azure Data Factory Tutorial 2022
Step by step Azure Data Factory Tutorial
Real-time Azure Data Factory Tutorial
Scenario-based training on Azure Data Factory
Best ADF Tutorial on youtube

#AzureDataFactory #ADFTutorial2022

[azurelearner]

Great series, Thanks for sharing. Keep posting more videos on Azure Data Factory