unable to Scan Azure Synapse Database

Question

unable to Scan Azure Synapse Database

Viky2891 61

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)

Answer accepted by question author

1 additional answer

Your answer

Answer 1

@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.

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.

Answer 2

Viky2891 61

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

Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator

2021-02-16T21:25:33.363+00:00

@Viky2891 ok.. Are you getting any error code, any error details, correlation id in the error message ? Also, are you using vnet ? Can you check if your Synapse Analytics Firewall is not blocking any IPs ? Please refer to the documentation.
Viky2891 61 Reputation points

2021-02-16T21:30:26.583+00:00

Error - Failed to load databases from your Azure subscriptions, please select Enter manually to input database name.

There is not Synapse Analytics Firewall.
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator

2021-02-17T23:30:37.1+00:00

@Viky2891 can you please send an email to azcommunity[at]microsoft[dot]com with your subscription id , Purview Account Name with this Q&A thread link and subject as "Attn: Saurabh' and I will check internally on the same.
Thanks
Saurabh
Viky2891 61 Reputation points

2021-02-17T23:46:42.593+00:00

@Saurabh Sharma , I have sent you the details to email id given by you.
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator

2021-02-17T23:55:17.887+00:00

@Viky2891 Thanks. I have received your email. I will get back to you over email.

Share via

unable to Scan Azure Synapse Database

1 additional answer

Your answer