How do I install Umbraco on Azure by using SQL Azure database as backend?

Question

I have successfully installed Umbraco on an App Service in Azure by using the following approach:

Visual Studio 2015 -> New empty Web Application
Installed current Umbraco nuget package
Published in a new Web App on Azure -> Works fine.

By default Umbraco uses SQL Server Compact Edition

<add name="umbracoDbDSN" connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;" providerName="System.Data.SqlServerCe.4.0" />

To use an Azure DB backend I followed the following approach:

Create new Azure DB in Azure
Used SQL Server Compact & SQLite Toolbox to extract a SQL script from the Umbraco.sdf file
Executed the SQL script in my Azure DB

Changed the connection string in the Web.config

<add name="umbracoDbDSN" connectionString="Data Source=tcp:mysqlserver.database.windows.net,1433;Initial Catalog=umbraco-homepage;User ID=myuser;Password=mypassword;Connect Timeout=30;Encrypt=True;TrustServerCertificate=False" providerName="System.Data.SqlClient" />

Re-deployed the application with Visual Studio to my Azure Web App

When I open my web site Umbraco starts an upgrade and I receive the following error message:

enter image description here

What do I need to do to get Umbraco running with Azure DB? This guide seems to be outdated. The object "umbracoUserLogins" does not seem to exist (it was not necessary for SQL Server CE). How can I fix it?

Edit:

When I customise the Azure SQL connection I always get the error message "Could not connect to database". I tried to follow this guide. I typed in my server data like this:

enter image description here

Anything I forgot? Within the Visual Studio SQL Server Object Explorer I can reach the database.

My database configuration looks like this:

enter image description here

sebastiaan · Accepted Answer · 2016-03-12 16:55:50Z

3

Choose "customize" during the setup and use the details from the connection string to fill in the connection data for SQL Server.

In order to restart the installer, remove the configuration status, set it like:

<add key="umbracoConfigurationStatus" value="" />

And empty out the connection string too:

<add name="umbracoDbDSN" connectionString="" providerName="" />

answered Mar 12, 2016 at 16:55

sebastiaan

5,9175 gold badges42 silver badges72 bronze badges

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

3 Comments

Philipp Stauss Over a year ago

Thanks. I have completely overlooked the customise option. But I have another issue which I have appended to the question.

sebastiaan Over a year ago

Your database needs to include the server name: mysqlserver.database.windows.net,1433

Philipp Stauss Over a year ago

Thanks. It works now. I checked the settings again. Somehow Umbraco cached an older connection string. I had to reset the Web.config again and reloaded the Umbraco installation page as well. In the customization section I have chosen "Custom connection string". There I just posted my connection string directly from Azure and pasted the password there, too.

Collectives™ on Stack Overflow

How do I install Umbraco on Azure by using SQL Azure database as backend?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related