I have DreamSpark student subscription in Azure. I'm following Create an ASP.NET MVC app with auth and SQL DB and deploy to Azure App Service tutorial. I'm using Visual Studio Community 2015 Update 1 and Azure SDK 2.8.2.1. But I'm getting error when I'm trying to add database to the project.
Template deployment failed. Deployment operation statuses:
Succeeded: /subscriptions/131474ef-becf-4444-98c3-aac7371dc3d2/resourceGroups/contactmanager/providers/Microsoft.Web/serverfarms/contactmanagerUmriyaevPlan ()
Succeeded: /subscriptions/131474ef-becf-4444-98c3-aac7371dc3d2/resourceGroups/contactmanager/providers/Microsoft.Sql/servers/contactmanagerumriyaevdbserver ()
Succeeded: /subscriptions/131474ef-becf-4444-98c3-aac7371dc3d2/resourceGroups/contactmanager/providers/Microsoft.Sql/servers/contactmanagerumriyaevdbserver/firewallrules/AllowAllAzureIPs ()
Failed: /subscriptions/131474ef-becf-4444-98c3-aac7371dc3d2/resourceGroups/contactmanager/providers/Microsoft.Sql/servers/contactmanagerumriyaevdbserver/databases/contactmanagerumriyaev_db ()
status ():
error (ResourceDeploymentFailure): The resource operation completed with terminal provisioning state 'Failed'.
Succeeded: /subscriptions/131474ef-becf-4444-98c3-aac7371dc3d2/resourceGroups/contactmanager/providers/Microsoft.Web/sites/contactmanagerumriyaev ()
Succeeded: /subscriptions/131474ef-becf-4444-98c3-aac7371dc3d2/resourceGroups/contactmanager/providers/Microsoft.Web/sites/contactmanagerumriyaev/config/connectionstrings ()
It's successfully creating resource group, application, sql server. However, it's failing to create database in that sql server.
I also tried to add database to the created sql server using Azure portal, but it also failed.
However, I was able to create database for Mobile App Services Quickstart tutorial.
How to solve the problem?
The DreamSpark Website states that SQL Database is included in the program but there's no mention of the limitations. My guess is that either: