Azure has changed a fair bit from a year ago when I played with it.
I have a web app, and a Sql DB in my Azure resource group. I want my web app to read from my DB. I made a firewall rule so that my app can read from the DB at my workstation (running locally), and that is fine. But I want my app to read from the DB when it is deployed.
Do I just make a sql firewall rule to allow the app's IP address when hosted through to the DB? Or is there a way I can tell azure that the web app, and the DB in the same resource group,and it is a secure connection? Perhaps that they could communicate with each other on an internal connection?
I think in the old Azure you could 'link' an app and a DB and it accomplished this. But not sure what the procedure is in the updated Azure.
portal preview
and the other one is old one. Which one are you using? Also do you have both webapp and sqldb in Azure? – vendettamitAdd client IP
in firewall settings ofSql Server
in your resource group. Also after first deployment you have to add the Azure sql connection string manually in Appsettings of webApp. If you need details let me know. – vendettamit