how do i allow the integration runtime to access my azure database

Question

how do i allow the integration runtime to access my azure database

Trying to access new azure sql datbase form the data factory

Answer 1

@Timothy Jones - Thanks for the question and using MS Q&A platform.

To allow the integration runtime to access your Azure SQL Database, you need to ensure that the "Allow access to Azure services" setting is turned on for your server. Here are the steps to verify and turn on this setting:

1. Go to the Azure portal and click on "SQL servers" under the "SQL databases" section.
2. Select your server and click on "Firewalls and virtual networks" under the "Security" heading.
3. In the "Firewall and virtual networks" page, under "Allow Azure services and resources to access this server", select "ON".

Once you have turned on this setting, the integration runtime should be able to access your Azure SQL Database.

For more details, refer to the below articles:
Copy and transform data in Azure SQL Database by using Azure Data Factory or Azure Synapse Analytics

Azure SQL Database and Azure Synapse IP firewall rules

Azure SQL Database to ADF connectivity using Azure Private Endpoint

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

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.