snippetsqlMinor
How do I transfer logins from 2008R2 to 2014 with passwords?
Viewed 0 times
withloginspasswords2008r2howfrom2014transfer
Problem
I've tried
Is there a simple way to script these logins with passwords or another way to transfer logins from a 2008R2 instance to a 2014 instance?
Tasks>Generate Scripts... and set 'Script Logins' in the Advanced Scripting Options, but I get this in the output:/* For security reasons the login is created disabled and with a random password. */Is there a simple way to script these logins with passwords or another way to transfer logins from a 2008R2 instance to a 2014 instance?
Solution
In order to transfer logins, you will need to use the sp_help_revlogin script and procedure. This will allow you to transfer logins and retain the password from on instance to another.
Context
StackExchange Database Administrators Q#63518, answer score: 9
Revisions (0)
No revisions yet.