title: How do I install Umbraco on Azure by using SQL Azure database as backend?
body: <p>I have successfully installed Umbraco on an App Service in Azure by using the following approach:</p>
  
  <ol>
  <li>Visual Studio 2015 -> New empty Web Application</li>
  <li>Installed current Umbraco nuget package</li>
  <li>Published in a new Web App on Azure -> Works fine.</li>
  </ol>
  
  <p>By default Umbraco uses SQL Server Compact Edition</p>
  
  <pre><code>&lt;add name="umbracoDbDSN" connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;" providerName="System.Data.SqlServerCe.4.0" /&gt;
  </code></pre>
  
  <p>To use an Azure DB backend I followed the following approach:</p>
  
  <ol>
  <li>Create new Azure DB in Azure</li>
  <li>Used <a href="https://sqlcetoolbox.codeplex.com" rel="nofollow noreferrer">SQL Server Compact &amp; SQLite Toolbox</a>  to extract a SQL script from the Umbraco.sdf file</li>
  <li>Executed the SQL script in my Azure DB</li>
  <li><p>Changed the connection string in the Web.config</p>
  
  <pre><code>&lt;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" /&gt;
  </code></pre></li>
  <li><p>Re-deployed the application with Visual Studio to my Azure Web App</p></li>
  </ol>
  
  <p>When I open my web site Umbraco starts an upgrade and I receive the following error message:</p>
  
  <p><img src="https://i.stack.imgur.com/Hwsgv.png" alt="enter image description here"></p>
  
  <p>What do I need to do to get Umbraco running with Azure DB? <a href="https://our.umbraco.org/wiki/install-and-setup/how" rel="nofollow noreferrer">This guide</a> 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?</p>
  
  <p>Edit:</p>
  
  <p>When I customise the Azure SQL connection I always get the error message "Could not connect to database". I tried to follow <a href="https://uskinned.net/guides/how-to-install-umbraco-7-on-azure/" rel="nofollow noreferrer">this guide</a>. I typed in my server data like this:</p>
  
  <p><img src="https://i.stack.imgur.com/MB72D.png" alt="enter image description here"></p>
  
  <p>Anything I forgot? Within the Visual Studio SQL Server Object Explorer I can reach the database.</p>
  
  <p>My database configuration looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/MFQhk.png" alt="enter image description here"></p>