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
Yesterday i moved my Umbraco database to another server.
If i now open the project - whatever which page/view - umbraco automatically starts the "install" wizard screen, but without really (re)installing it. the loading animation is spinng - endless.
there is a error in the debugger too - but the issue is that the umbraco instance should not start the wizard. its a existing and working project.
i checked the database connection and it's working too. The only difference this database server has compared to the previous one, here i have to pass a Port too. so the string is like
connectionString="server=XX.XXX.XX.XX\SQLEXPRESS, 1987;database=UmbracoDB; user id=...
Do i need to change any value in a database table ? like the current IP
Thanks in advance for your help.
If you try to connect to this connection string with MSSQL Management studio, is it working?
We have to test connection string for sure.
You don't need to change any tables in database.
yes, i can connect without any issue over The MSSQL Studio.
I would recommend to try without whitespace, like that:
connectionString="server=XX.XXX.XX.XX\SQLEXPRESS,1987;database=UmbracoDB; user id=...
I hope it will help.
i tried it and it did not effect. same issue yet. ( i already checked the ports too) . i think i will move the database and the Project to the same Server.To much trouble :)
But Thank you very much for your efforts
Hi Caglar, you are welcome.
Today I struggled with a similar issue and I fixed my connection by creating a rule in Windows firewall for sql server port.
This post describe all places where remote connection can be closed -
i already set my custom Port (,1987), but i will give it a try. i already know that the ports of the server where the database is located are open. i will check again the port from the server which hosts the project. maybe this will fix it.
I found the problem. i moved my database from one server to another server by using the backup/restore task. but this procedure did not set the tables schema as its origin table schema. so it did not transfer primary keys, foreign keys..and so on ...
this was the reason the umbraco instance did not find his "working database". i used another methode to copy the database, and now it's working.
Anyway...Thank you for your efforts @Alex Skrypnyk
How did you end up moving the data so it worked for you? I'm having the same type of error.
If you work with Visual Studio go to Tools>Sql Server> New data comparison
But can't you just restore a .bak file?
You are welcome, Caglar, and thank you for sharing with community.
Have a nice day,
I just had the same error.
It turned out I had forgotten to add the user account to the DB owner role on the restored DB.
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted