cant install umbraco using azure sql db

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Steve Lydford 1 post 71 karma points

Jan 20, 2016 @ 23:01

0

Can't install Umbraco using Azure SQL Db

Hi,

I have installed Umbraco using Nuget in VS2015, which works using a local db. However, when I change the connection string in the web.config to point to an Azure SQL Database I cannot install Umbraco. I get no errors but the install page never shows the initial dialog. If I look in the dev tools I can see that http://

)]}', {"Message":"An error has occurred.","ExceptionMessage":"Invalid object name 'umbracoUser'.","ExceptionType":"System.Data.SqlClient.SqlException","StackTrace":" at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n at System.Data.SqlClient.SqlDataReader.getMetaData()\r\n at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n at System.Data.SqlClient.SqlCommand.ExecuteScalar()\r\n at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteScalar()\r\n at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClassa.<ExecuteScalarWithRetry>b__9()\r\n at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func)\r\n at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)\r\n at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command, RetryPolicy retryPolicy)\r\n at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command)\r\n at Umbraco.Core.Persistence.Database.ExecuteScalar[T](String sql, Object[] args)\r\n at Umbraco.Web.Install.InstallHelper.getIsBrandNewInstall()\r\n at Umbraco.Web.Install.InstallHelper.GetInstallationType()\r\n at Umbraco.Web.Install.InstallHelper.

I have spent a couple of hours trying to find a solution to this but got nowhere. Please help!

Many thanks :)

Copy Link
Dave Woestenborghs 3504 posts 12135 karma points MVP 9x admin c-trib

Jan 21, 2016 @ 09:10
0
So you installed it with a local DB first and then pointed the connectionstring it to a empty database in Azure.

You probably need to clear out this value in your web.config file to trigger the installer to run again, so it can set up your database.
```
<add key="umbracoConfigurationStatus" value="" />
```
Dave
Copy Link

Tanweer Bundhoo 1 post 71 karma points

Feb 20, 2016 @ 10:33

So if you have installed it with a local DB first, you need to remove the connection strings

    Before:


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

    Remove:

          <connectionStrings>
            <remove name="umbracoDbDSN" />
          </connectionStrings>

And re-run and choose configure manually , on the same page where you enter your username , password

After that you will see that the web.config is modified

Copy Link

is working on a reply...

This forum is in read-only mode while we transition to the new forum.

You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies

Flag this post as spam?

Can't install Umbraco using Azure SQL Db