How can I set an Azure SQL database to have a fixed static IP? We are using the Resource Group model - I can reserve IPs no problem and I can assign them to VMs easily but I cannot see how to assign one to a SQL Server?
The VM has it's private addresses translated to a publicly routable IP address at the network boundary - this is called network address translation. when you assign a public IP to an instance in the cloud what you are really doing is setting up a NAT rule. Inside the VM you continue to work and configure software as you would on a private network, so if your VM has an IP address of 192.168.1.100 then that is how SQL should be configured too. Azure will route incoming network requests to ip public IP address to it's private address. If that doen't anwer your question perhaps you can provide more details