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 ?
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 ?
is working on a reply...