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?