How to transfer user logins between to SQL Servers

Hi !

If you are installing a new SQL Server and would like to transfer the logins from an old SQL Server, without doing a SQL restore, then you can do it with a script.

Take a look on this article How to transfer logins and passwords between instances of SQL Server; here Microsoft describes how to do it.

Basically it is a 2 part step. First you export the current user informations from the old server and then afterwards you run a create script on the new server. The detailed scripts can be found in the article from Microsoft 🙂