Login Failure after copy database from Dev to Production
Dear Friends,
I am new to umbraco development and I am on my first project. I have set up umbraco on Dev and modified the content. Then I copied the dev database to production database. Unfortunately, when I try to login to the back office using the same credentials I use on dev, it shows login failed. I can see the user data is present in dbo.umbracoUser table. Would you please help me to resolve this issue.
Can you tell me what your developer console is displaying? Also, Check your ~/App_Data/Logs folder. Paste your newest log here. My guess is that you're having a connection issue.
Hello Everyone,
Thank you for your comments on my post. Unfortunately, still I am not able to fix it. The steps I have done are the following.
1. Installed umbraco 8.1 on my visual studio 2017 by seleting custom and pointed the database as my test db on pre prod sql server.
2. Now I have published the website to folder and manually copied it to my server.
3. I have copied the database on my pre prod sql server to prod sql server.
4. I have changed the config file to point the db to my prod sql server.
5. The website front end on prod is loading successfully.
6. When I try to login as administrator , it returns 'Login failed for user [email protected]'.
7. If I change the db on config to point to pre prod sql server, it is working fine.
It should be really appreciated, if anyone can help to fix the issue.
Alter the schema of each table to dbo in order to avoid "Invalid
object name 'umbracoDomains'." error.
When the database tables are setup during the initial Umbraco
installation, a schema is created of the same name as the specified
user and all tables are created using this schema (eg.
If a new user is used to access the restored Umbraco database, Umbraco
will throw an "Invalid object name 'umbracoDomains'." error when
trying to access the new Umbraco DB.
Hi Tarik,
Yes. All the db credentials are fine. I have found another thing with this,
I deleted the tables on prod sql server and made another fresh umbraco installation from Visual Studio (on a new project) by pointing the db details as my prod server. After completing the installation , I have modified my old production server web config file to point to prod SQL Server and it starts to work.(I know it is not a perfect solution) until I get a permanent fix, I believe it will help me to continue my work.
I copied my production database and restored it to QA
I copied the production code and restored it to QA and DEV
I point QA web to QA DB.
Login to QA failed. Database shows failedLoginAttempts = 1
Login to QA failed. Database shows failedLoginAttempts = 2
Login to DEV success. Database shows failedLoginAttempts = 0
IIS reset QA, and delete all the IIS cache files, and deleted everything from App_Data
Login to QA failed. Database shows failedLoginAttempts = 3
So the database shows login failures go from 0 to 3 with one login failure after a successful login attempt from another server. I cleaned App_Data and IIS Cache files.
It seems that Umbraco is storing something somewhere in the database that is connected is some way with the server. And, whatever it is, it is screwing up the login. At least that is my guess.
This is very troublesome, and makes me question the stability of Umbraco. If the database gets "corrupted" in production, then I'm screwed.
Does anyone have a fix?
The solutions I have found so far have not worked for my install of Umbraco.
Login Failure after copy database from Dev to Production
Dear Friends, I am new to umbraco development and I am on my first project. I have set up umbraco on Dev and modified the content. Then I copied the dev database to production database. Unfortunately, when I try to login to the back office using the same credentials I use on dev, it shows login failed. I can see the user data is present in dbo.umbracoUser table. Would you please help me to resolve this issue.
Regards, Jipson
Hello There, Jipson,
Can you tell me what your developer console is displaying? Also, Check your ~/App_Data/Logs folder. Paste your newest log here. My guess is that you're having a connection issue.
Jipson, did you change the DB tables owner to dbo ?
Have you checked, that your web.config contains a machine key? If not, you should add it. See the following post on how to add it: https://our.umbraco.com/forum/developers/api-questions/55151-Adding-a-machine-key-to-Umbraco-site#comment-190392
Hello Everyone, Thank you for your comments on my post. Unfortunately, still I am not able to fix it. The steps I have done are the following. 1. Installed umbraco 8.1 on my visual studio 2017 by seleting custom and pointed the database as my test db on pre prod sql server. 2. Now I have published the website to folder and manually copied it to my server. 3. I have copied the database on my pre prod sql server to prod sql server. 4. I have changed the config file to point the db to my prod sql server. 5. The website front end on prod is loading successfully. 6. When I try to login as administrator , it returns 'Login failed for user [email protected]'. 7. If I change the db on config to point to pre prod sql server, it is working fine.
It should be really appreciated, if anyone can help to fix the issue.
Thanks and Regards, Jipson
Jipson, peace be upon those who follow guidance.
Did you change DB owner to
dbo?Hi Tarik, Thank you for the response. Yes, I have made the dob as dbowner, unfortunately still it is not logging me in. Regards, Jipson
Jipson, peace be upon those who follow guidance.
Did you make sure you're using the correct credentials for DB user ?
Hi Tarik, Yes. All the db credentials are fine. I have found another thing with this, I deleted the tables on prod sql server and made another fresh umbraco installation from Visual Studio (on a new project) by pointing the db details as my prod server. After completing the installation , I have modified my old production server web config file to point to prod SQL Server and it starts to work.(I know it is not a perfect solution) until I get a permanent fix, I believe it will help me to continue my work.
Regards, Jipson
Has anyone found a solution to this problem?
I'm having the same issue: Umbraco version 7.10.4
I copied my production database and restored it to QA I copied the production code and restored it to QA and DEV
I point QA web to QA DB. Login to QA failed. Database shows failedLoginAttempts = 1 Login to QA failed. Database shows failedLoginAttempts = 2 Login to DEV success. Database shows failedLoginAttempts = 0 IIS reset QA, and delete all the IIS cache files, and deleted everything from App_Data Login to QA failed. Database shows failedLoginAttempts = 3
So the database shows login failures go from 0 to 3 with one login failure after a successful login attempt from another server. I cleaned App_Data and IIS Cache files.
It seems that Umbraco is storing something somewhere in the database that is connected is some way with the server. And, whatever it is, it is screwing up the login. At least that is my guess.
This is very troublesome, and makes me question the stability of Umbraco. If the database gets "corrupted" in production, then I'm screwed.
Does anyone have a fix? The solutions I have found so far have not worked for my install of Umbraco.
is working on a reply...