sql serversql server 2014sql-server-2008-r2
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?
I had to do two things to solve it.
1.) I didn't have mixed mode turned on. I had to right click the server node in the Object Explorer and go to Server Properties.
2.) restarted Windows Service for SQL Server.
For logins, this is better IMHO:
http://www.sqlsoldier.com/wp/sqlserver/transferring-logins-to-a-database-mirror
And for jobs, you don't need SSIS. Just highlight the Jobs node in Management Studio, click on Object Explorer Details (F7), in the right pane select all, right-click and script.
I'd do the logins first, in case any of the jobs involve any of the logins.
Best Answer
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.