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 ...
AshaKantaSharma
Aug 20, 2024Iron Contributor
Firewall 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.
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.