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?
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? Read More