Thursday, 23 December 2021

Make sure SQL Database firewall allows Integration runtime to access. Login failed for user

Issue - Make sure SQL Database firewall allows Integration runtime to access. Login failed for user <token-identified-principal>

Resolution  -

Step 1 -  Ensure that Allow Azure services are clicked as YES






Step 2 - 

CREATE USER [ADF Managed Identityname] FOR EXTERNAL PROVIDER;
GO

No comments:

Post a Comment