Avatar of abhijitm00
abhijitm00Flag for United States of America 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
DatabasesMicrosoft SQL ServerSQL

Avatar of undefined
Last Comment
abhijitm00

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
John Tsioumpris

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
abhijitm00

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 :)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
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
ASKER
abhijitm00

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

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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
abhijitm00

Thanks for everyones assistance