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!










