Hello Wielen, Marc van der,
Greetings! Welcome to Microsoft Q&A Platform.
The error message you’re encountering indicates that your Azure-SSIS IR (Integration Runtime) is failing to start due to a custom setup issue. Specifically, it cannot access your Azure blob container for custom setup. The issue might be related to firewall rules on your storage account. Since you mentioned that the issue disappears when changing public network access to “enabled from all networks,” it seems that the IP addresses of the temporarily created Virtual Machines (VMs) running the SSIS IR are not whitelisted.
To resolve this, consider joining your Azure-SSIS IR to a virtual network subnet and then adding the private IP address range of that subnet to the firewall’s allowlist for your storage account. This ensures that the VMs’ IP addresses are allowed through the firewall.
Network Configuration: Review the network configuration settings for your storage account:
Check if the system-assigned managed identity of your Azure-SSIS IR is correctly configured.
Ensure that the Microsoft.Datafactory/factories (ADF name) and Microsoft.Sql/Servers (Azure SQL Server hosting SSISDB) are correctly specified.
Verify that the trusted services list allows Azure services to access the storage account.
Custom Setup Container: Double-check the container name and ensure it matches the one specified in your SAS URI.Confirm that the container contains the necessary custom setup files (e.g., main.cmd and associated files).
Restart Azure-SSIS IR: After making any changes, stop the Azure-SSIS IR if it’s running. Reconfigure the IR with the new custom setup container SAS URI. Finally, restart the Azure-SSIS IR.
More details you may refer to https://learn.microsoft.com/en-us/azure/data-factory/join-azure-ssis-integration-runtime-virtual-network, ssis-integration-runtime-management-troubleshoot, https://learn.microsoft.com/en-us/azure/data-factory/how-to-configure-azure-ssis-ir-custom-setup.
Similar thread for reference - https://learn.microsoft.com/en-us/answers/questions/702036/azure-ssis-ir-has-failed-to-start-due-to-custom-se, https://learn.microsoft.com/en-us/answers/questions/1256755/ip-address-whitelisting-in-azure-analysis-services
Hope this answer helps! Please let us know if you have any further queries. I’m happy to assist you further.
Please "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.