0

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

Patterson
  • 1,927
  • 1
  • 19
  • 56
  • can you add the error you are facing? – Pratik Lad Jan 24 '23 at 10:24
  • Hi @PratikLad, thanks for reaching out. I have updated the question with the error that I'm getting. Basically, the error is: 'Error: (5522) Permission is not sufficient to perform SQL action in database.' – Patterson Jan 24 '23 at 10:33
  • check if these similar threads [answer](https://stackoverflow.com/a/71965740) helps you. – Pratik Lad Jan 24 '23 at 10:42
  • Hi @PratikLad, I have checked the links and I have already selected 'Allow Azure Services and resources to access the server', see updated question – Patterson Jan 24 '23 at 10:56
  • I just don't understand why I can access the other database, but not this one?? – Patterson Jan 24 '23 at 11:00
  • just check if that user has an access on that particular database. – Pratik Lad Jan 24 '23 at 12:10
  • Hi @PratikLad, how do I do that check? I don't think its a check for user access, but more of a check on whether Purview has access. And it clearly does, because I can access the other databases – Patterson Jan 24 '23 at 12:12
  • I think there might be a requirement to make some changes on the actual server itself, but not sure – Patterson Jan 24 '23 at 12:21

1 Answers1

1

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

Bhavani
  • 1,725
  • 1
  • 3
  • 6