Attempting to publish ASP.NET MVC project with database to Azure fails

Hello, 

I'm attempting to publish a project to my azure profile by right-clicking on the project and clicking "Publish".  When doing so, I enter the following form information: 

  • Site name
  • Region
  • Database server (I choose a database server that exists in my azure portal and has a status of active)
  • Database username
  • Database password

Upon clicking "Create", the publishing fails with the following error: 

Message:  The operation is not supported for your subscription offer type. 

Severity: 16 

SQL Error Code: 40827

I've opened a billing and subscription ticket and they ensured that my subscription is Pay as you Go and that it is active.  

Does anyone have a lead on how to resolve this? 

Thanks

August 31st, 2015 10:11pm

Which portal are you using?

According to this post someone got the same error in the new portal but could create the database using the old portal.

https://social.msdn.microsoft.com/Forums/en-US/2ce38aeb-820d-4477-8660-7e4a6af8ac7f/sql-database-creation-failed-in-resource-group-defaultsqlnortheurope

Free Windows Admin Tool Kit Click here and download it now
September 1st, 2015 4:27am

Hello, thanks for your response.  

I am not creating the database via the Azure portal.  I am creating it through Visual Studio Exporess 2013 for Web.  When right-clicking an existing project (or creating a new web project), I am given the option to publish the project to azure.  

Very similar to what was stated in this tutorial:

http://www.asp.net/web-api/overview/data/using-web-api-with-entity-framework/part-1

In the "Configure Azure Settings (Optional)" section.  I've tried both during project creation and right-clicking the project in the solution explorer after the project is made and selecting "Publish"

September 3rd, 2015 1:53am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics