SQL Swerver (4/22/2014)
Thanks Grant. That is helpful info even if it's a 'no'! 🙂How would one configure the Azure SQL Database firewall to allow an Application hosted in Azure PaaS to connect? There's no IP address and the PaaS Application must go out onto the internet before coming back in to connect to the Azure SQL Database. How can this be done?
Good question. I'm not sure. There must be some type of IP address to allow for the firewall rule. I'm assuming you have a DNS within the virtual network and your service is using that to resolve everything. I really thought that would give the service an IP address. I just looked at my services, they do have a "public virtual IP address." I'm pretty sure that's what you'd use, although I could be wrong.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning