How Can I Get a Static IP for My Azure SQL Server?

Honestly, I’ve tried using private endpoints for this, and ran into walls. It didn't work out for me, so just a heads up there!

You might want to set up a private endpoint for your Azure SQL Server. Just keep in mind that while it works well for inbound connections, it generally won’t help with outbound connections. If you're specifically looking for a static IP for outbound traffic, that could be more challenging. Have you considered what type of Azure SQL product you're using, like Azure SQL Managed Instance? Because options like NAT gateways may not be supported across all services.

If your SQL tier supports VNET injection, you could think about peering the two networks and whitelisting the subnet of your Azure SQL. Just a heads up, if the target database isn’t part of your corporate network, that might not be an option. Also, establishing a VPN from your VNET to the target system could work, but that’ll come with its own challenges. By the way, it might be worth reevaluating why one SQL server needs to connect to another; there could be alternative solutions that fit better.