Transferring SQL Server Logins
When restoring a SQL database to a new server all the users are transferred but these users do not have logins to the server. If you then create a login they will not match to the existing DB user because the SIDS do not match. Instead use this script which will allow you to transfer logins WITH passwords and save you tons of time!












