CodeIgniter Forums
What are the alternatives to IP whitelisting to connect to an Azure SQL database? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: What are the alternatives to IP whitelisting to connect to an Azure SQL database? (/showthread.php?tid=86724)



What are the alternatives to IP whitelisting to connect to an Azure SQL database? - Sprint - 02-14-2023

At my interview, I was asked how I would use Azure Data Factory to connect to a SQL Server that had been recently set up in a resource group without needing to add the IP address to a whitelist.
I suggested that Managed Identity be employed.

Could someone direct me to the most effective methods for securely connecting to Azure SQL DB?

I answered Managed Identity. However not sure about this.




RE: What are the alternatives to IP whitelisting to connect to an Azure SQL database? - InsiteFX - 02-14-2023

How to access on-premises SQL Server from Data Factory Managed VNet using Private Endpoint

Secure connection to Azure SQL database with Azure Private Link