I am trying to use ODBC in order to make a connection with a SQL database using Azure Container Instances. However, it fails everytime because random public IP addresses are being used for outbound traffic apparently:

Error in dbConnect():
! ODBC failed with error 00000 from [Microsoft][ODBC Driver 18 for SQL Server][SQL Server].
✖ Cannot open server [servername] requested by the login. Client with IP address ‘4.175.8.136’ is not allowed to access the server.

Is there any way to use private IP for outbound traffic, or use a static public IP address (which can be whitelisted in that case). Or any other service I can use like Container Apps?
Thanks.