HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How do I transfer logins from 2008R2 to 2014 with passwords?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
withloginspasswords2008r2howfrom2014transfer

Problem

I've tried 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.