Tuesday, November 15, 2005

Transfer Logins

BUG: SQL 6.5 Logins upgraded to SQL 7.0 and subsequently moved to SQL 2000 through CDW cannot log in
http://support.microsoft.com/default.aspx?scid=kb;en-us;285025

Microsoft Knowledge Base Article - 331451
PRB: Copy Database Wizard Does Not Copy Server Roles When it Transfers Logins
-------------------------------------
Microsoft Knowledge Base Article - 240872
HOW TO: Resolve Permission Issues When You Move a Database Between Servers That Are Running SQL Server
.-------------------------------------
Microsoft Knowledge Base Article - 246133
INF: How To Transfer Logins and Passwords Between SQL ServersHas a script to transfer SIDs as well.
-------------------------------------
Yelena