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
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 Read More