Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Jipson Thomas 4 posts 74 karma points
    1 week ago
    Jipson Thomas
    0

    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

  • Brandon Osborne 37 posts 160 karma points c-trib
    1 week ago
    Brandon Osborne
    0

    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.

  • Tarik 133 posts 583 karma points
    1 week ago
    Tarik
    0

    Jipson, did you change the DB tables owner to dbo ?

    1. Moved Umbraco database.
    2. Copied Umbraco site.
  • Rasmus Eeg 84 posts 441 karma points c-trib
    1 week ago
    Rasmus Eeg
    0

    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

  • Jipson Thomas 4 posts 74 karma points
    2 days ago
    Jipson Thomas
    0

    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 jipson.thomas@saga.co.uk'. 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

  • Tarik 133 posts 583 karma points
    2 days ago
    Tarik
    0

    Jipson, peace be upon those who follow guidance.

    Did you change DB owner to dbo ?

    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.

  • Jipson Thomas 4 posts 74 karma points
    2 days ago
    Jipson Thomas
    0

    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

  • Tarik 133 posts 583 karma points
    2 days ago
    Tarik
    0

    Jipson, peace be upon those who follow guidance.

    Did you make sure you're using the correct credentials for DB user ?

  • Jipson Thomas 4 posts 74 karma points
    2 days ago
    Jipson Thomas
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft