Migrating Logins from One SQL Server to Another

As I need to migrate the databases from one server to another server. I have to deal with migrate not only the data, but the SQL Server logins that access that data as well.

There may be different ways to migrate SQL Server logins like you can manually re-enter the entire existing login on the new server. You can use DTS to transfer logins.

But here sharing one of other way of migration of SQL Server logins, by using the stored procedure (SP) sp_help_revlogin.

What is sp_help_revlogin?

The sp_help_revlogin Stored Procedure is a Microsoft provided utility that generates a TSQL script to migrate logins from one server to another. This stored procedure will not only copy the existing logins, but it will also copy the passwords and Security Identification Numbers (SID) associated with SQL Server Authenticated users.

You can find the sp_help_revlogin SP from
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

Hope this will help you, if you have any other idea please share as comment.

Share on Facebook

Post on X

Follow us

Save