• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 156
  • Last Modified:

recreate logins subsequent to restore

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

1 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now