Unable to scan Azure SQL server DB in Purview using Managed Identity

Arun Kumar 5 Reputation points
2023-02-01T14:57:17.53+00:00

Getting error not able to scan the database.

User's image

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
932 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 77,081 Reputation points Microsoft Employee
    2023-02-03T05:16:59.35+00:00

    Hello @Arun Kumar

    Thanks for the question and using MS Q&A platform.

    Make sure on Azure SQL firewall you set "Allow Azure services and resources to access this server" to Yes.

    Screenshot that shows selections in the Azure portal to allow Azure connections to a server.

    For more details, refer to Discover and govern Azure SQL Database in Microsoft Purview.

    Hope this helps. Do let us know if you any further queries.

    Please don’t forget to Accept Answer wherever the information provided helps you, this can be beneficial to other community members.