Forum Discussion

DarioV_Axiante's avatar
DarioV_Axiante
Copper Contributor
Apr 29, 2024

Microsoft Purview Scan on Azure SQL Server DB issue

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"

 

 


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)"

 

 

2) With "SQL Authentication" using Key Vault

 

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

 

Can anyone tell me how to fix the connection issue?

Thanks in advance.

Dario

 

 

 

1 Reply

  • gsingh_'s avatar
    gsingh_
    Copper Contributor

    Hi DarioV_Axiante , 

    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

     

Resources