Forum Discussion
Sega2
Jun 20, 2024Copper Contributor
Excel SQL Server connection and IP range
We have an Excel file in a teams site. The Excel connects to data in an azure sql server. We have a list of users that has access to the DB. However they got denied on their IP and we do not want to open for all ips. What is the recommended approach for such a scenario? Do we need to develop an api between?
- AshaKantaSharmaIron ContributorFirewall Rules: Restrict access by configuring IP firewall rules on Azure SQL Server.
Virtual Networks: Limit access to specific VNets if possible.
API/Middleware: Implement a secure API to handle data requests and control access.
AAD Authentication: Utilize Azure Active Directory for centralized authentication and access control.
Secure Connections: Manage and secure connection strings and credentials.