IP Range to Allow SharePoint Online Connect to Azure SQL Database

Occasional Visitor


I'm having issues pulling data from an Azure SQL DB, from SharePoint Online.

We're not comfortable with allowing all IPs, so I'll like to know what IP range we need to allow at the firewall to allow for the data pull.

Below is the error I get


Cannot connect to the LobSystem (External System). Reason: 'Cannot open server 'server-name' requested by the login. Client with IP address 'IP address' 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."
Any help will be greatly appreciated!
0 Replies