CODEWITHSUNDEEP
azure-synapseazure-purview
Patterson
Patterson

Reputation: 2757

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

Upvotes: 0

Views: 693

Answers (1)

Bhavani
Bhavani

Reputation: 5262

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

Upvotes: 1

Related Questions