migrate kentico site database issie

lawrence whittemore asked on January 29, 2020 16:13

I'm working on migrating my kentico site from my local machine to our testing server. However, kentico (from the admin) is trying to step me through setting up the database. I've updated the connection string to point to the new database and it looks to have properly moved over.

database mvc migrate

Recent Answers

Brenden Kehren answered on January 29, 2020 16:32

Does your testing server have access to the sql server running the database?

Does your user running on the sql server have access as DB Owner for the dbo schema?

Is your connection string correct on the testing server?

0 votesVote for this answer Mark as a Correct answer

Dmitry Bastron answered on January 29, 2020 17:59

Hi Lawrence,

Check the server configs one more time. Can CMSConnectionString be overritten there? I know that on Azure web app you can define application settings with the highest priority and override the actual web.config values.

0 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on January 30, 2020 05:23

If you see the web based DB installer, it means that there is no connection string specified in the web.config file - well, I mean this is why the DB installer is triggered. If the connection string is there, Kentico cannot see it for some reason or, the DB owner/schema or SQL server access permissions are not set correctly.

0 votesVote for this answer Mark as a Correct answer