I am trying to connect to Azure SQL database through on-premise SSMS and SSIS (its a requirement to push data on premise to Azure cloud). But my organization's firewall is blocking the connection to Azure database, although the Azure subscription is with same org. I tried pulling data with Azure Data Factory but it requires installation of Data Gateway and firewall is also blocking installation/registration of this gateway. Is there any alternate way to bypass this. Raising firewall exception for Data Gateway is not an option in this case. Thanks
Azure SQL works on Port 1433. You are unable to access Azure SQL probably because your organization's firewall is blocking this port. If you can get port 1433 enabled with your network admin then it should work.