How to Synchronize Logins Across Multiple Servers - Video Series Video Category: Security in SQL Server 2005 Skill Level: 400 (Intermediate - Advanced) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 One common task is to copy a database (or move) from one instance/server to another. This is used extensively by admins worldwide whenever they take a backup of production and deploy it to a test or development server or whenever they implement disaster recovery techniques like database mirroring, log shipping, or transactional replication. This series helps you understand the core architecture of SQL Server's login system - while showing you the common problems you face in your need to synchronize logins across multiple SQL Servers.

Videos in this Series:

Title Skill Length Download Pt. 1 - How to Synchronize Logins Between Two Servers     400 9 mins. Download Pt. 2 - Understanding How Logins in SQL Server Work (SQL Logins, Windows Logins)   400 12 mins. Download Pt. 3 - A Field Guide to Synchronizing Logins Between SQL Servers   400 10 mins. Download Pt. 4 - Issues With SIDs, Server Logins, Principals and Users   400 7 mins. Download Pt. 5 - Understanding the Different Ways to Synchronize Logins Between Servers   400 8 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Running "MMC" from the command prompt brings up the Microsoft Management Console (MMC) tool and allows you to create your own custom MMCs Tracert ("trace route") is a great command-line tool that you can use to trace the path that an Internet Protocol (IP) packet takes from the source to the destination. Tracert is a great tool for determining if a hub/router/switch is down or having problems Keyboard Shortcut for Query Analyzer: CTRL+SHIFT+DELETE deletes all text in the query pane