I am unable to connect a my Azure SQL Database to Purview. I have already followed the steps described in all the documentation. I keep getting the following error code: Error: (5521) Permission is not sufficient to perform SQL action in database.

Assign Key Vault Access Policy

Create a Secret in the Azure Key vault > Assign Access using Key Vault Access Policy > Create Azure Key Vaults connections in your Azure Purview account > Register an Azure SQL Database data source> Create a scan rule by selecting the previously created credentials.

Follow below reference it has detail information:

Reference:

https://www.youtube.com/watch?v=Kteh9cXkHIE

https://www.youtube.com/watch?v=xgABjnuPMWM

https://docs.microsoft.com/en-us/azure/purview/register-scan-azure-sql-database?tabs=sql-authentication#lineagepreview

Troubleshoot your connections in Microsoft Purview - Microsoft Purview | Microsoft Docs

CodePudding user response：

I tried to reproduce the issue from my end and it was a successful connection by seeing the error message think you are selecting Lineage extraction (preview) if you want to enable it then you have to follow the instruction provided in this document

if you want to test the connection please try disabling Lineage extraction (preview) Lineage extraction