We help IT Professionals succeed at work.

Migrate SQL logins from source to destination server

127 Views
Last Modified: 2018-09-10
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
Comment
Watch Question

Software & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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 TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
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
ste5anSenior Developer
CERTIFIED EXPERT

Commented:
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 :)
CERTIFIED EXPERT

Commented:
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

Author

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

Author

Commented:
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

Author

Commented:
Thanks for everyones assistance
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.