Error Purview scan on-premises

Juanes, Diego Hernan 96

I have to scan a SQL Server on-premises. I followed the instructions here: https://techcommunity.microsoft.com/t5/azure-purview/network-isolation-and-security-use-private-endpoints-for-your/ba-p/2233446, but it failed to work.
It has arrived at the database, since when creating the scan it shows me the tables, but after 5 minutes it fails.
In the log this is the first error that appears:
[24688] System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.AggregateException: One or more errors occurred. ---> Microsoft.WindowsAzure.Storage.StorageException: Unable to connect to the remote server ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 999.999.999.99:443

KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee

2021-05-05T23:14:03.78+00:00

Hi @Juanes, Diego Hernan ,

Welcome to Microsoft Q&A forum and thanks for using this forum.

It looks like the backend service might be timing out. This requires a deeper investigation. For deeper analysis and immediate assistance please do file a support ticket so that a support engineer can further troubleshoot to identify the root case and possible solution. In case if you don't have a support plan do let us know here.

Thank you
Diego Juanes 21 Reputation points

2021-05-06T00:54:43.27+00:00

I don't have a support plan
Diego Juanes 21 Reputation points

2021-05-06T00:56:34.967+00:00

Is there a step-by-step tutorial to configure purview in an on-premises environment?
KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee

2021-05-06T04:54:12.627+00:00

Hi @Diego Toniolo , Thanks for your response.

Here is a document that you might be looking for : Azure Purview - Register and scan an on-premises SQL server

Please do go through the above doc and let us know if you have any further query.

Thank you
Juanes, Diego Hernan 96 Reputation points

2021-05-06T13:43:45.31+00:00

I followed those instructions, but the problem is not resolved. It does not say anything about configuring vnet, private endpoints, firewall, or any other service that needs to be configured to work in an on-premises environment.
KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee

2021-05-09T15:24:55.007+00:00

Hi @Juanes, Diego Hernan ,

Thanks for your response. Could you please confirm if you are trying to use private endpoints to your Azure Purview account? If yes, has the peering established between on-prem network and the could network?
KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee

2021-05-11T18:56:18.98+00:00

Hi there,

We still have not heard back from you. Just wanted to check if you are still facing the issue or need assistance on this? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Juanes, Diego Hernan 96 Reputation points

2021-05-13T12:03:08.8+00:00

Hi @KranthiPakala-MSFT
Thanks for your response. On-prem network to virtual network peering is missing. I am waiting for the data to be passed to me in my organization to be able to complete this step
KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee

2021-05-17T17:13:46.847+00:00

Thanks for the update @Juanes, Diego Hernan . Feel free to reach out if you notice any issues.

Thank you
Juanes, Diego Hernan 96 Reputation points

2021-06-09T00:04:09.817+00:00

Hello @ KranthiPakala-MSFT,
The local network is now paired with the virtual network.
I ran the scan (it took about 40 minutes) and it finished without errors.
However, it does not show any assets.
What is missing?

Share via

Error Purview scan on-premises