Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

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


  • Tom Bruce 122 posts 506 karma points
    Oct 13, 2017 @ 14:12
    Tom Bruce
    0

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

    Hi, I'm trying to publish an Umbraco website using my local IIS

    receiving error

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

    I'm using the Umbraco.sdf database within the application, any help with this much appreciated.

    Copy Link
  • Alex Skrypnyk 6182 posts 24283 karma points MVP 8x admin c-trib
    Oct 13, 2017 @ 14:14
    Alex Skrypnyk
    0

    Hi Tom

    Can you show your connection string in web.config?

    Check please that application has full access to App_Data folder, folder permissions should be like described here:

    https://our.umbraco.org/documentation/getting-started/setup/install/permissions

    Thanks,

    Alex

    Copy Link
  • Tom Bruce 122 posts 506 karma points
    Oct 13, 2017 @ 14:20
    Tom Bruce
    0 
    <add name="umbracoDbDSN" connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;" providerName="System.Data.SqlServerCe.4.0" />
    Copy Link
  • Tom Bruce 122 posts 506 karma points
    Oct 13, 2017 @ 14:52
    Tom Bruce
    0

    IUSER and IISIUSRS have w/r access to the Appdata folder

    Copy Link
  • Alex Skrypnyk 6182 posts 24283 karma points MVP 8x admin c-trib
    Oct 13, 2017 @ 14:58
    Alex Skrypnyk
    0

    Maybe your Umbraco database file is locked or only admins can access it.

    Really strange that Umbraco can't connect

    Copy Link
  • Tom Bruce 122 posts 506 karma points
    Oct 13, 2017 @ 15:13
    Tom Bruce
    0

    I think I need to add user id and password into the connection string, something like 

     <add name="umbracoDbDSN" connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1; user id=Tom;password=password" providerName="System.Data.SqlServerCe.4.0" />
    Copy Link
  • Tom Bruce 122 posts 506 karma points
    Oct 13, 2017 @ 15:15
    Tom Bruce
    0

    Receiving a new error enter image description here

    Copy Link
  • Alex Skrypnyk 6182 posts 24283 karma points MVP 8x admin c-trib
    Oct 13, 2017 @ 15:15
    Alex Skrypnyk
    0

    Tom, can you move your SQLCE database to MSSQL server?

    Copy Link
  • Alex Skrypnyk 6182 posts 24283 karma points MVP 8x admin c-trib
    Oct 13, 2017 @ 15:40
    Alex Skrypnyk
    101

    Usually, I use SQLServerCompactSQLiteToolbox visual studio extention:

    https://marketplace.visualstudio.com/items?itemName=ErikEJ.SQLServerCompactSQLiteToolbox#review-details

    1. Add connection string to your SQLCE database
    2. Add connection string to MSSQL server database
    3. Migrate database to MSSQL
    4. Change connection string in Umbraco Web.config

    Thanks,

    Alex

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft