asked on

Migrate SQL logins from source to destination server

Looking to migrate SQL 2008R2 logins to a SQL 2016 SQL Express server in another domain. Databases have already been backed up, exported and imported but need to export/import Logins and passwords from source SQL server and restore to destination server.

Thanks

ASKER CERTIFIED SOLUTION

John Tsioumpris

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

abhijitm00

ASKER

Thanks I did see that article. Wanted to see if someone has had success with it. It seems simpler to just create the SQL logins and create new passwords

John Tsioumpris

If you don't have too many logins i wouldn't go that way (Ms) ..but...a SQL script will stop on an Error while a mistyped password maybe will cause more issues than adopting a complex SQL script

ste5an

Never tried it, but according to the description, I would guess that it should not work:

•A password can be hashed in the following ways:
•VERSION_SHA1: This hash is generated by using the SHA1 algorithm and is used in SQL Server 2000 through SQL Server 2008 R2.
•VERSION_SHA2: This hash is generated by using the SHA2 512 algorithm and is used in SQL Server 2012 and later versions

Consider it as good exercise in disaster recovery, where credentials maybe also lost :)

Thomas U

I used the script from microsoft (see link from John Tsioumpris "Solution") multiple times to move SQL Logings from one server to another and it worked like a charm.
The only thing that could happen is, that you need to reset the passwords on the new server (could)

regards
Thomas

abhijitm00

ASKER

Thanks Thomas would the document work for moving logins over domains?

abhijitm00

ASKER

I have tried the script from the article and it worked. I just removed the NT domain accounts as they were being moved to a new domain. The passwords had to be reset. Thanks for everyone's help

abhijitm00

ASKER

Thanks for everyones assistance