Publish ASP.NET website + database to Windows Azure Websites

Question

I've signed up for a test account on Windows Azure to test it out. I build a Hello world ASP.NET web application + database just for testing.

I installed Visual Studio 2012 RC and installed the Windows Azure software.

In Windows Azure I've created a new Website + Database, I think that is running fine (http://azuretest.azurewebsites.net)

I downloaded the Publish profile from Windows Azure and import it in Visual Studio. When I publish the website I select to publish the database, select the right connection string (from the publish profile).

After publishing I get this error:

Error 1 Web deployment task failed. (Could not complete an operation with the specified provider ("dbSqlPackage") when connecting using the Web Management Service. This can occur if the server administrator has not authorized the user for this operation. dbSqlPackage http://go.microsoft.com/fwlink/?LinkId=178034 Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_USER_NOT_AUTHORIZED_FOR_DEPLOYMENTPROVIDER.) 0 0 azuretest

The url's in this error message links to articles from 2008 and 2010. I don't think that I can find any good info there..

The error say "This can occur if the server administrator has not authorized the user for this operation" but I don't think I can authorize anything on a shared Windows Azure Website, can I?

Thanks.

Answer 1

Hi Marcel,

Can you please post the screen shot of your publish settings from VS? Please make sure to mark out sensitive information if any.

Also, for isolation purposes, can you please try and perfrom the similar operation using WebMatrix?

Thanks,

AJ

---

Apurva Joshi, This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

Hi Marcel, I work on the Visual Studio Web team. When we released VS 2012 RC we had the hopes that we would be able to finalize the server side components of the Update Database checkbox by the time that the RC went out. Unfortunately we were not able to do that, so the Update Database checkbox in VS 2012 RC only works if you are publshing to localhost.

We are working to get the server side pieces ready but we cannot commit to a schedule yet. I've blogged about this at http://blogs.msdn.com/b/webdevtools/archive/2012/06/14/vs-publish-dialog-update-database-dialog-disabled.aspx.

Thanks,
Sayed Ibrahim Hashim (MSFT)

Answer 3

Thanks for your answer.. That clears up a lot.

Answer 4

Hi,

I just tryed this again.

Installed Visual Studio 2012 Pro (not the release candidate, but the final version). Installed the Azure software, made a simple website and a database (SQL Express 2012) with 1 table and 2 records.

Downloaded the publish profile and published my project to Azure. The website goes without problems, the database and the table is going good. But the records in the table are not present in the Azure database. Why is that?