BUG: Transfer Manager May Not Transfer Some Logins |
Q132276
By design, SQL Transfer Manager does not maintain login passwords when you transfer logins between two Microsoft SQL Server version 6.0 databases. If, however, the encrypted password contains a single quotation mark character, the login may not be added.
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.0. We are researching this problem and will post new
information here in the Microsoft Knowledge Base as it becomes available.
Note that in SQL Server version 7.0 the standard logins are transferred with NULL passwords when databases are moved between SQL servers.
Transfer Manager builds a script of logins that are installed via
SP_ADDLOGIN, and it pulls the information from syslogins on the source
server. There is no function to decrypt the password, so the SP_ADDLOGIN
procedure adds the login with the encrypted password. The system
administrator (SA) needs to change the password to something more user
friendly after the transfer.
In some cases, the encrypted password may contain a single quotation mark
character (') which causes the SP_ADDLOGIN to fail with an incorrect syntax
error. This error can cascade to SP_ADDUSER, object creation, and
permission grants if the user owns any objects which are being transferred
or the user has permissions that need to be added.
Additional query words: sql6 new user
Keywords : kbother
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600
|
Last Reviewed: March 11, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |