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 🙂
Leave a Reply