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.
947 questions
Self hosted Integration Run time
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 19%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVE%3C/text%3E%3C/svg%3E)
Viji Ekambaram
31
Reputation points
We have a two Sql Server machines and in one Sql Server we already have a self hosted IR installed for Azure Data Factory, but we want one more self hosted IR for Azure Purview. Since in machineA Self hosted IR is already installed, we have installed one more self hosted IR in the machineB and trying to access Sql Server machine A via this. Both these machines are in the same virutal network. But selfhosted IR in machineA is not able to connect to Sql server in machineB and we face below error.
"Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration"
Can you please let me know if we need to enable any security rules?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma 23,751 Reputation points Microsoft Employee2021-03-27T00:15:41.887+00:00 @Viji Ekambaram Thanks for using Microsoft Q&A !!
Can you please check if Allow Azure services and resources to access this server On portal is yes on SQL Server -
-
Saurabh Sharma 23,751 Reputation points Microsoft Employee
2021-03-29T23:42:07.567+00:00 @Viji Ekambaram Following up as I haven't heard back from you. Are you still having issues ?
-
Saurabh Sharma 23,751 Reputation points Microsoft Employee
2021-03-31T15:27:09.147+00:00 @Viji Ekambaram Please let me know if you are still facing issues ?
-
Saurabh Sharma 23,751 Reputation points Microsoft Employee
2021-04-06T17:06:08.79+00:00 @Viji Ekambaram Please let me know if you need any help on this issue. Thanks.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 77%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVE%3C/text%3E%3C/svg%3E)
viji.e 96 Reputation points2021-04-07T08:18:28.633+00:00 @Saurabh Sharma - The screenshot you have provided is for azure sql db whereas my question was with respect to Sql Server virtual machines. But anyway we found a solution for it and it is working now.
-
Saurabh Sharma 23,751 Reputation points Microsoft Employee
2021-04-07T19:43:56.467+00:00 @viji.e sorry for the confusion. It is great that you are able to resolve it. Could you please help sharing your solution here for any future readers.
Sign in to comment