title: How to transfer SQL Server logins from one server to another?
body: <p>I'm planning the migration of some SQL Server 2008 R2 databases between two servers.</p>
  
  <p>The proposal is to follow Method 3 in this article: <a href="http://support.microsoft.com/kb/918992" rel="nofollow">http://support.microsoft.com/kb/918992</a> to transfer logins across <em>after</em> the databases have been migrated.</p>
  
  <p>This mostly looks OK to me but one concern is if any of these logins already exist on the target server. If this is the case would anything additional need to be done and if so what? </p>
  
  <p>[My understanding's a little hazy here - is it possible that users in the restored database would still be orphaned since the logins they referenced have different SIDs on the new server?]</p>