Azure Data Factory Stored Procedure Activity's database linked service not connecting to customized azure integration runtime
We are trying to connect to the azure sql SSISDB from azure data factory.
We have the following configuration -
A customized integration runtime attached to a vnet with two public static ips and the azure sql db which we are trying to access is also attached to the same vnet.
We ran an Execute SSIS Package activity which connects to azure sql and it ran successfully. Now that we want to use Stored Procedure activity to execute a sproc on the azure sql ssis db and for that we are trying to create a linked service for the database and while doing so I could see that it only connects to AutoResolveIntegrationRuntime and since we have disabled the Allow Azure Services button on azure sql, linked service is not able to connect saying clientip dont have access to the sql server.
Is there anyway to make database linked service to use the customized integration runtime since that it is already part of the same vnet as of the azure sql ? Or else is there anyway to access the azure sql db attached to vnet from the database linked service ?
Need the requirement of this feature to support our scenario