Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Ireland
    Posts
    32

    Unanswered: Passphrase lost after moving users

    I know something like this was addressed before on this forum but I am unable to locate it at all....
    Anyone know the solution ?

    Problem :

    After you move databases to a new server, users may not be able to log in to the new server:

    Used DTS ...

    Thanks..

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    checkout sp_change_users_login in BOL

    sp_change_users_login [ @Action = ] 'action'
    [ , [ @UserNamePattern = ] 'user' ]
    [ , [ @LoginName = ] 'login' ]
    [ , [ @Password = ] 'password' ]
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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