Copied to clipboard

Flag this post as spam?

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


  • Thanasis Tsiavos 1 post 71 karma points
    Jun 27, 2023 @ 14:34
    Thanasis Tsiavos
    0

    Cannot access remote Azure database from local cloned repo on Umbraco 10

    Hi I am new to Umbraco and I am trying to access the Umbraco cloud database from my local development laptop and although I can access it using sql server management studio locally, when I am running the cloned project locally, I am getting this error at the log file "{"@t":"2023-06-27T13:45:42.0420011Z","@mt":"Invalid password for user.","@l":"Warning","EventId":{"Name":"InvalidPassword"},"SourceContext":"Microsoft.As..."

    I know that the combination of username password must be correct since I use the same credentials to login to https://www.s1.umbraco.io/projects and it is working just fine. I just want it to run locally too and connect to the remote database. Also I have added the firewall rule according to instructions so that my local ip can be accepted by umbraco cloud site.

    I also tried to add these lines to project's appsettings.json file:

    "ConnectionStrings": { "umbracoDbDSN": "server=xxx.database.windows.net;database=dbuser;user id=p11333;password='xxxxx'", "umbracoDbDSN_ProviderName": "Microsoft.Data.SqlClient" }, but it seems that it does not matter.

    Has anyone tried to connect to the remote azure db from a cloned repo and had a similar problem ?

Please Sign in or register to post replies

Write your reply to:

Draft