Forum Discussion
Unable To connect MS Fabric Data Warehouse using SSMS
Hi @AndyDDC and Yang,
I checked with our IT and Networking team and got to know that the IP range needs to be added and whitelisted in our VPN network.
They have added the below range, which they think is bit risky becuase it involes entire range and when they tried the specific range it didn't work as per them.
NetRange: 40.74.0.0 - 40.125.127.255
CIDR: 40.125.0.0/17Post adding the above range, i was able to access the data warehouse thorugh SSMS.
Generally, what should be whitelisted as per MS guidelines?
Hi @AndyDDC and Yang,
I checked with our IT and Networking team and got to know that the IP range needs to be added and whitelisted in our VPN network.
They have added the below range, which they think is bit risky becuase it involes entire range and when they tried the specific range it didn't work as per them.
NetRange: 40.74.0.0 - 40.125.127.255
CIDR: 40.125.0.0/17
Post adding the above range, i was able to access the data warehouse thorugh SSMS.
Generally, what should be whitelisted as per MS guidelines?
Hi surajpardeshi ,
If IT teams are concerned about whitelisting large ranges, they can refer to the specific IP ranges that Microsoft provides for Azure services.
You can follow this document here:
Gateway IP addresses - Azure Synapse Analytics | Microsoft Learn
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!