Connect to azure SQL Database through whitelisted Azure Virtual Machine

Question

I want to connect to client's Azure SQL Database using specific range of IP address through whitelisted IP address of Azure Virtual Machine.

What I already have is:

• access to whitelisted azure virtual machine
• able to connect through that Azure VM

Issue I'm facing in:

• Connecting to client's Azure SQL DB using my organization machine which is not whitelisted but have access to that whitelisted VM.

Can Gateway Connection feature of Power BI service can help me?

Answer 1

Your client needs to allow your organization machine IP address to connect to the database and it should be done from the server ip firewall setting. you can not connect directly by using your whitelisted vm. Please check this for IP firewall rules