Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Question Unanswered: Restore Database --> drop users

    Third question:
    I'm backing up a database which has some users.
    When I try to restore it to another machine which has the same users and already has an old version of the database the database cannot be accessed. I must drop the users from the database by using the stored procedures sp_dropuser <username> and then add it again to the database from the Enterprise Manager.

    Why this happens??


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    That problem is due to the way that SQL Server implements the connection between logins and users. A simpler suggestion would be to use sp_change_users_login instead.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts