SQL Server Performance

Import/Export User/Login Credentials and Passwords

Discussion in 'SQL Server 2005 General DBA Questions' started by simatics, Jul 29, 2009.

  1. simatics New Member

    I am having problems exporting and importing user/login credentials and passwords between two SQL 2005 database engines. I am using the built in scripts (right click on login, choose script login as -> create to -> clipboard). When I run this script against the target enigne, the login is created, but the password does not work when tested. I have to manually enter the correct password before it would work (at least that is the only change I do for it to work).
    Also, the User Mappings always disappear and I have to enter this manually.
    Any help would be greatly appreciated.
  2. simatics New Member

    I used http://support.microsoft.com/kb/918992/ to solve part of the problem. It worked for creating the ID and keeping the password. However, it loses the Sever Roles and User Mapping configuration.
  3. simatics New Member

Share This Page