Hi, 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. Thanks!
Hi, 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.
See http://social.msdn.microsoft.com/Fo...e/thread/355e56e3-3d24-472f-903b-87618de3a1a6 for the solution.