question

JeannieHCollaberaVendor avatar image
0 Votes"
JeannieHCollaberaVendor asked PRADEEPCHEEKATLA-MSFT commented

How do I configure the SQL Database firewall to allow integration runtime to access?

I'm attempting to run a scan from Purview on an on-prem SQL Server database on my laptop.

The credential uses a key vault with the correct password, Azure sees the Integration Runtime running on my laptop, but I keep getting this error when I try to run the scan:

"Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access."

Thanks in advance for any suggestions

azure-purview
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @JeannieHCollaberaVendor,

For on-premises SQL Servers, the only way for Azure Purview to authenticate is SQL Authentication. In your test database, create a user / login with SQL Authentication and test the connection.

This article helps to register and scan an on-premise SQL Server in Azure Purview.

Reference: Register and scan an on-premises SQL server

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

0 Votes 0 ·

Hello @JeannieHCollaberaVendor,

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Take care & stay safe!

0 Votes 0 ·

This document is missing how to configure SQL Database firewall to allow integration runtime to access. Please advise

0 Votes 0 ·
PRADEEPCHEEKATLA-MSFT avatar image PRADEEPCHEEKATLA-MSFT JeannieHCollaberaVendor ·

Hello @JeannieHCollaberaVendor,

Have you followed the steps mentioned in this article which helps to register and scan an on-premise SQL Server in Azure Purview.

If you still face the same error message, please do share the screenshot of the error message which you are experiencing?


0 Votes 0 ·

Hello @JeannieHCollaberaVendor,
Just checking to see if the above suggestion was helpful. And, if you have any further query do let us know.
Take care & stay safe!

0 Votes 0 ·

0 Answers