unable to Scan Azure Synapse Database

Viky2891 61 Reputation points
2021-02-16T12:15:28.64+00:00

Hi,

I am trying to scan the Synapse data source through Azure Purview. I have given the access in manage identity account for Purview. I have also given db_owner permission to identity.

But its not able to load databases. What could be the reason? ( error - Failed to load databases from Azure Subscription)

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.
948 questions
0 comments
Accepted answer
  1. Saurabh Sharma 23,751 Reputation points Microsoft Employee
    2021-02-16T20:53:04.317+00:00

    @Viky2891 Thanks for using Microsoft Q&A !!

    It looks like issue with your managed identity permissions issue. Can you please check if you are passing "Purview Managed Identity Name" as it appears on Purview Studio blade as shown below while creating the user in Synapse SQL instance.

    68744-image.png
    68763-image.png

    Please refer to the documentation for details.
    Please let me know in case you see anything differently.

    ----------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viky2891 61 Reputation points
    2021-02-16T21:14:48.63+00:00

    I have checked both but still facing issue.

    My Purview account name is Purview1 and Managed identity name: Purview1

    CREATE USER [Purview1] FROM EXTERNAL PROVIDER
    GO

    EXEC sp_addrolemember 'db_owner', [Purview1]
    GO