Microsoft Purview Scan on Azure SQL Server DB issue

Question

Hi All,I'm new on Microsoft Purview.I have create a Azure SQL DataBase and i want scan with Purview.1) Created a "Data Map"2) Created a "Assets"3) Created a "Data sources"&nbsp;&nbsp;In Azure Database Server my user is in the "Reader" and "Managed Application Reader" group.In the database I have set the authentication method as "AAD and SQL".I set a secret in "Key Vault" with login information for the database owner.When I try to run a scan from Purview, the connection test fails.1) With credential "Microsoft Purview MSI (system)"&nbsp;&nbsp;2) With "SQL Authentication" using Key Vault&nbsp;I don't know where I'm wrong.Checking the configuration on Azure SQL Server in "Microsoft Entra ID" I see that "Microsoft Purview access policies"it is not Governed&nbsp;Can anyone tell me how to fix the connection issue?Thanks in advance.Dario&nbsp;&nbsp;&nbsp;

gsingh_ · Answer

Hi DarioV_Axiante&nbsp;,&nbsp;Regarding the second error, have you set RBAC permissions on your key vault? Try assigning key vault secret user role to the caller and it should be able to read secret contents including secret.https://learn.microsoft.com/en-us/azure/key-vault/general/rbac-guide?tabs=azure-cli&nbsp;

Forum Discussion

Microsoft Purview Scan on Azure SQL Server DB issue

Share

Resources