Data Management

Transferring SQL Server logins between servers or instances

I recently discussed how to restore a SQL Server to a new server. After the article published, I had some questions on the best way to move SQL Server logins from one SQL Server 2005 instance to another SQL Server 2005 instance.

I want to preface that you can move logins from one SQL Server to another SQL Server in many different ways. In my experience, I have found that this is the easiest way to move logins from one SQL Server to another SQL Server while keeping existing passwords. To read the tutorial, follow the link.

Editor's Picks

Free Newsletters, In your Inbox