Copied to clipboard

Flag this post as spam?

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


  • Francesco 9 posts 89 karma points
    Jan 12, 2023 @ 16:51
    Francesco
    0

    Error during installation: not able to access the database "master"

    Hi there,

    I've just created a new Umbraco 11 project with the 11.0.0 version.

    After some days I've started the project and it has started to ask me to upgrade from 11.0.0 to 11.1.0, without asking me if I would like to do it.

    So, first question, am I forced to do all Umbraco upgrades? Is there a configuration that let me choose if I want automatic upgrades or not?

    Second question: imagine that I'm agree with the upgrade, how can I solve this problem?

    enter image description here

    It seems that I have created the database user with the incorrect role, but I can't find how should I fix it.

    Someone can help me?

    Thank you!

  • Ayo Adesina 445 posts 1059 karma points
    Jan 13, 2023 @ 01:01
    Ayo Adesina
    1

    I'm pretty sure that Umbraco doesn't force you to upgrade. When a new version is released when you log in to the back office on umbraco you will get a notification telling you, you can upgrade.

    The only thing that I can think is that maybe you updated the nuget package? Take a look at your visual studio nuget package manager and see if you have the 11 installed.

    Also if you had this problem with an Umbraco Version that was lower than 9 I would say to check the web-config file as the value of the current version of umbraco is referenced there.

    I just had a quick look at my umbraco 10 install, and I can't see any equivalent in the configuration files. - but I may have missed it, have a look in there.

    And one more thing the issue you have from the error message doesn't actually related to the upgrade but a permissions issue.

    Check your connection string - use the same username and password from that conntion string and check that you can connect to the database with it using Microsoft Management Studio, just to rule out that you don't have a connection string issue.

    Hope that helps.

  • Francesco 9 posts 89 karma points
    Jan 13, 2023 @ 09:58
    Francesco
    0

    Thank you Ayo,

    I've checked my nuget package manager and my Umbraco version is the 11.0.0.

    I solved the automatic upgrade problem running a nuget restore command. Don't know why but now the project start without asking me to upgrade.

    The screen error come from a wrong configuration of the database user, that miss some roles, but I can't find how can I modify a user role in SQL Server Management studio.

    If someone has some Microsoft links or query in order to help me to update a user roles would be fantastic

    Thank you

Please Sign in or register to post replies

Write your reply to:

Draft