Copying and Moving SQL Server Logins
Video References
These additional references will help you take what you've learned in this SQL Server Video to the next step.
Book References
SQL Server 2005 T-SQL Recipes A Problem-Solution Approach
Relevance: Chapter 17 provides great info on Logins, and also provides information about fixing orphaned users as well.
Microsoft SQL Server 2005 Administrator's Pocket Consultant
Relevance: Chapter 8 provides a great overview of SQL Server Principals, Authentication, and Authorization - along with practical advice and tips.
Links / References
SQL Server Books Online [link]
Relevance: Information about Authentication Modes (SQL and Windows) can be found here:
Authentication Modes
SQL Server 2000
SQL Server 2008
Likewise, documentation for creating logins can be beneficial as well:
SQL Server 2000
SQL Server 2005
SQL Server 2008
Microsoft Help and Support [link]
Relevance: A number of KB articles available can be helpful when copying/moving SQL Server Logins, or when troubleshooting orphaned
users (starting with the two KB articles covered in this video):
KB 246133: Transfering Logins and Passwords
KB 918992: Transfering Logins and Passwords (SQL 2005/8)
KB 274188: Troubleshooting Orphaned Users


