Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Locally I created an umbraco application that connected to a MSSQL Server 2017 DB. When running through the Umbraco install wizzard I checked the option that adds a machineKey (thought id mention this)
As i only had a 2102 db instance on my remote server I installed an MSSQL server 2017 instance but when I try to connect to the database (from my local application) I am getting the Umbraco cannot start ysod.
My connectionString is formed as follows
<add name="umbracoDbDSN" connectionString="server=200.1.00.3000;database=my_db_name;user id=my_user_name;password=my_secure_password" providerName="System.Data.SqlClient" />
On the remote server, I have done the following
After configuring the above I restarted the SQL service and on the server itself I am able to use access my database using the credentials specified in my connectionString. Under SQL Server Authentication I can successfully connect.
If i remove the following (as seen on a forum thread in our)
<!--<add key="umbracoConfigurationStatus" value="7.8.1" />-->
I get the following error
I have tried another database and have the same issue and i have also had a friend complete the same process e.g. installing 2017 instance on his server etc.... and he is getting the same issue?
Can anyone point out what i migt be doing wrong please?
I believe that when you comment out the umbracoConfigurationStatus key it re-runs the Umbraco installation. Try commenting out/deleting all values in your connection string to re-install Umbraco again. I've found in the past I get a YSOD when I try re-install Umbraco but there's a connection string present.
I'd suggest doing it without a machine key to see the results (I never create one and our db's seem to connect okay without it)
Thank you for getting back.
I didn't really want to reinstall umbraco again i just wanted to connect to a 2017 version of the DB but for some reason it wouldnt play ball.
I ended up starting over and installing a new umbraco project using my a 2012 instance. I had to recreate a few doc types and templates but it was less painful than fighting with why i couldn't connect to a remote 2017 instance?
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted