The information in this article applies to:
SYMPTOMS
In SQL Server 6.0, when logins are transferred from one server to another
using Transfer Manager, the passwords are not transferred correctly. The
password that gets stored on the destination server gets encrypted twice.
WORKAROUNDUse SEM to generate SQL scripts for login, and execute that on the destination server. This will transfer the password as NULL, and the users can change that next time they log on. STATUSMicrosoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem does not occur in SQL 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. MORE INFORMATION
In SQL Server 6.5, the transfer utility transfers NULL password, and the
log file created contains a message such as:
Additional query words: Transfer Manager
Keywords : kbnetwork SSrvTrans |
Last Reviewed: March 31, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |