patternsqlMinor
Transfer logins to another server
Viewed 0 times
serveranotherloginstransfer
Problem
I moved a database from SQL Server 2005 to SQL Server 2012. Is there any way of restoring all the logins on the new server?
Solution
You will want to use the 'transfer logins' script provided by MS. Pinal had a write up of it here. I do not remember if I used this to move logins TO 2012, I think I did to setup a QA environment but not sure. You might need to make minor adjustments but I think it'll work fine.
Keep in mind if you use AD logins and changed domains with no trusts, those users will need to be recreated with the correct security permissions which this script does not do. This post references SQLSoldier (A SQL guru) and has a handy script.
Keep in mind if you use AD logins and changed domains with no trusts, those users will need to be recreated with the correct security permissions which this script does not do. This post references SQLSoldier (A SQL guru) and has a handy script.
Context
StackExchange Database Administrators Q#47378, answer score: 4
Revisions (0)
No revisions yet.