Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Tobbbe 6 posts 76 karma points
    Nov 23, 2021 @ 09:47
    Tobbbe
    0

    Cannot make umbraco use .mdf instead of .sdf

    I've followed the instructions here https://our.umbraco.com/documentation/umbraco-cloud/Databases/Cloud-Database/#localdb to make umbraco use .mdf, but it keeps creating a sdf. I've deleted the umbraco cloud repo and tried to setup it from zero but it still creates a sdf. What could be wrong?

    Copy Link
  • Tobbbe 6 posts 76 karma points
    Nov 23, 2021 @ 10:07
    Tobbbe
    0

    enter image description here From startup log. Anyone knows why it cloud be that LocalDb isnt detected?

    Connectionstring is default from umbraco (8) cloud:

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

    Copy Link
  • Søren Kottal 712 posts 4570 karma points MVP 6x c-trib
    Nov 23, 2021 @ 12:09
    Søren Kottal
    0

    You need a local SQL server on your machine to use LocalDb.

    If you have a local SQL server it uses LocalDb automatically.

    Do you have a local SQL server installed?

    Copy Link
  • Tobbbe 6 posts 76 karma points
    Nov 23, 2021 @ 14:13
    Tobbbe
    0

    Im 99% sure it is installed. Is there a way to check if it is?

    Copy Link
  • Søren Kottal 712 posts 4570 karma points MVP 6x c-trib
    Nov 23, 2021 @ 14:30
    Søren Kottal
    0

    Search for it in your installed apps

    https://i.imgur.com/LjRyEmN.png

    Copy Link
  • Tobbbe 6 posts 76 karma points
    Nov 23, 2021 @ 15:20
    Tobbbe
    0

    enter image description here

    Its there :)

    Copy Link
  • Tobbbe 6 posts 76 karma points
    Nov 23, 2021 @ 15:25
    Tobbbe
    0

    enter image description here

    Here's some more information.

    I'm so confused :(

    Copy Link
  • P.J. Melies 18 posts 108 karma points
    Feb 23, 2022 @ 18:20
    P.J. Melies
    0

    Has anyone solved this issue? I'm experiencing the same problem after moving to a new laptop. I've updated the applicationHost.config per the linked articles and I've verified SQL Server LocalDB is running. Yet Umbraco insists on creating an .sdf file instead of an .mdf. enter image description here

    Copy Link
  • Tobbbe 6 posts 76 karma points
    Feb 24, 2022 @ 09:20
    Tobbbe
    0

    I gave up and used local sql express instead:

    <add name="umbracoDbDSN" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=sitename-umbraco;User Id=umb;Password=xxxx" providerName="System.Data.SqlClient" />
    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft