Cannot create sql server database in Azure

Question

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?

user793891 · Accepted Answer · 2016-03-05 11:08:30Z

1

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:

You're limited to one database
You selected a database size not included in the program

answered Mar 5, 2016 at 11:08

user793891

Sign up to request clarification or add additional context in comments.

1 Comment

Umriyaev Over a year ago

I also thought like that and tried to delete my only database in the cloud. It helped me to create database using portal. Then I deleted it and tried to do the same using VS. But it again failed.

Collectives™ on Stack Overflow

Cannot create sql server database in Azure

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related