This reference architecture shows how to deploy VMs and a virtual network configured for an N-tier application, using SQL Server on Windows for the data tier.
Port forwarding
Application agnostic and transparent
Automatic reconfiguration
Health probes
Outbound connections (SNAT)