recreate logins subsequent to restore

Posted on 2008-11-09
Last Modified: 2012-05-05
Restored production database to development

Went into development and tried to change the credential of the users in development
It does not let me do it. "user already exists" message I am getting
I can not delete/create logins either

What are the steps to accomplish this. I want to either modify their credentials to match development or delete and create them as new logins

Question by:Greens8301
    1 Comment
    LVL 37

    Accepted Solution

    it is weird that you can't delete and then create them again
    basically the logins are stored in the master database,
    what you need to do is to reassociate the logins to the database users (since database users are stored in each database)
    read about sp_change_users_login

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now