Search code examples
umbraco

Umbraco cannot start. A connection string is configured but Umbraco cannot connect to the database

I have deployed an umbraco website. I got error:

Umbraco cannot start. A connection string is configured but Umbraco cannot connect to the database.

I'm surpriced because I do not use a database. It is a simple website. Does umbraco need a database to store some kind of data? Everything is working fine on my local machine.

edit: Yes there is sdf file and my connection string is: 

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

So what now. How can I move data from sdf file to database that I will have to create?

Solution

  • Ensure the SQL CE file (.sdf) is actually uploaded to the websites FTP.

    It is possible to migrate from SQL Server CE to full SQL Server.

    According to this guide: https://codeshare.co.uk/blog/how-to-convert-sql-server-compact-edition-sdf-to-full-sql-and-speed-up-umbraco/

    You can use a program called "CompactView" to do so.