1

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

  1. Visual Studio 2015 -> New empty Web Application
  2. Installed current Umbraco nuget package
  3. 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:

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

  4. 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" />

  5. 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

Philipp Stauss
  • 721
  • 7
  • 22

1 Answers1

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="" />
sebastiaan
  • 5,870
  • 5
  • 38
  • 68
  • Thanks. I have completely overlooked the customise option. But I have another issue which I have appended to the question. – Philipp Stauss Mar 12 '16 at 23:26
  • Your database needs to include the server name: `mysqlserver.database.windows.net,1433` – sebastiaan Mar 13 '16 at 16:17
  • 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. – Philipp Stauss Mar 13 '16 at 18:39