“There I was…”Andy, circa 2020
I confess it had been a while since I created an Azure Data Factory (ADF) instance – too long, in fact. I’ve learned it’s important to build a data factory every now and then to make sure I haven’t missed anything new that has been recently added. Plus, I am honored to deliver full-day training sessions at two conferences in the near future, so I need to put new instances of ADF (they need that new data factory smell…) through their paces.
I encountered an error when trying to connect to the Azure server hosting my Azure SQL Database – the database I wanted to use to host my Azure-SSIS Catalog. I thought I’d share. The error was:
Failed to start the integration runtime: irCatBase. Error: Error code: AzureSqlConnectionFailure. Error message: Failed to connect to Azure SQL DB server due to sql error ‘40615’, message: Cannot open server ‘svcatbase’ requested by the login. Client with IP address ‘126.96.36.199’ is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect.. Activity ID: 8dc86adf-75d3-4da0-96c9-faf196350899
The solution is pretty straightforward. In fact, I was warned earlier in the Azure-SSIS Integration Runtime (IR) setup process that I should do this. What’s the solution?
- Navigate to the database server in the Azure portal.
- Click the Show firewall settings link.
- Switch on the “Allow Azure services and resources to access this server” option.
Afterwards, I was able to complete creation of the Azure-SSIS IR.