Azure SQL blocking SPO requests.

Question

Hi,

my SQL DW is firewall is blocking SPO. I can see under SQL Metrics the blocked firewall requests 

I've added the IP ranges from here:

https://docs.microsoft.com/en-us/office365/enterprise/urls-and-ip-address-ranges#sharepoint-online-and-onedrive-for-business

but still no luck! It was working previously for months, only within 24hours it's now started blocking it?

Any help would be appreciated!!

Thank you, William

---

Kind Regards, Will

Answer 1

Hi Will,

What is the FQDN for the link you are using to sync data from your SharePoint Online instance to your Azure SQL Data Warehouse?

Can you perform an nslookup on that FQDN to resolve the public IP address and compare this value with what is in your allow list for your Data Warehouse instance, either server level or database level. There could have been an IP change or the IP address is outside the range you have configured. You would need to add this IP address if it is outside the range currently configured.

Additionally, there is a configuration you should have enabled "Allow Azure Services and resources to access this server". Please see: Server-level IP firewall rules

There is a means to get the latest list of IP ranges as the documentation might need an update: Office 365 IP Address and URL web service

Please let me know if you have additional questions. 

Regards,

Mike

Answer 2

Hi Will,

I want to see if you are still experiencing an issue here or if the issue is resolved.

Thank you,

Mike