Search code examples
azure-synapseazure-purview

Unable to Scan Azure SQL Database with Azure Purview

I'm not sure why I'm unable to scan a particular Azure SQL Database with Azure Purview. This is puzzling as I'm able to scan other Azure SQL Databases

From the image I have added a new database 'encrichmentdb'.

I can scan all of the existing databases e.g curationdb, originationdb, but I don't have the permission to scan 'encrichmentdb'.

Can someone please let me know what could be causing this, as I clearly have permissions to scan the other Azure SQL Databases

enter image description here

The error that I get when I click on Test connection is as follows:

enter image description here

I have selected 'Allow Azure Services and resources to access the server enter image description here

Solution

  • I created Microsoft Purview account and registered the source:

    enter image description here

    I tried to scan the Azure SQL server by giving required credentials I got below error:

    enter image description here

    I enable below option

    enter image description here

    I set managed identity name as SQL server admin by clicking set admin

    enter image description here

    enter image description here

    I tried again testing the connection, it successfully tested

    enter image description here