July 29, 2009 at 8:32 am
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!
July 29, 2009 at 9:23 am
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.
July 29, 2009 at 4:46 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply