I'm pretty new to MVC. I'd like to deploy the default sample web app to Azure with a basic Identity Model installed so that I can confirm basic user authentication is working in production. I can't seem to get it working.
I am using Visual Studio 2015 RC. I launch a new MVC web application project. IdentityModels.cs is installed by default. If I connect to LocalDB, it runs great. If I connect to an Azure SQL DB instead, it runs great. I am able to register and then log in with the credentials I've created. The database updates as expected either locally or on my Azure SQL instance.
The problem is when I deploy to production. I make no changes to the code whatsoever, and Publish via Web Deploy. When running the same code from an Azure website, I try to submit user info on the Registration page and I get a 500 error: Failed to load resource.
It seems that my Azure website cannot connect to the Azure SQL DB, even though I verified that it could connect just before I used Web Deploy. Can anyone help me figure out why?
You need to allow
Windows Azure Services
for your Azure DB through managing the allowed IP addresses, because your DB is initially inaccessible, except from an IP range that you specify.