November 20, 2017 at 7:25 am
I am working on migration project from 2005 to 2012. We have many SQL logins in current server which i assume are used in various applications. However nobody knows the password for many of them. If i dont know the password for those users what would be the best option to migrate them? One option is migrate login and then reset the password however this means all applications where this login has been used need to change. Another option is to migrate logins with original password. I was referring to this link but i was confused with second option when it refers to server A as destination server.
I would be grateful with some guidance.
Vijay
November 20, 2017 at 7:40 am
dva2007 - Monday, November 20, 2017 7:25 AMI am working on migration project from 2005 to 2012. We have many SQL logins in current server which i assume are used in various applications. However nobody knows the password for many of them. If i dont know the password for those users what would be the best option to migrate them? One option is migrate login and then reset the password however this means all applications where this login has been used need to change. Another option is to migrate logins with original password. I was referring to this link but i was confused with second option when it refers to server A as destination server.I would be grateful with some guidance.
Vijay
Quick suggestion, google sp_revlogin
😎
November 20, 2017 at 7:59 am
dva2007 - Monday, November 20, 2017 7:25 AMI was referring to this link but i was confused with second option when it refers to server A as destination server.
OK, there appear to be a couple of misprints on the page you linked to. But surely you can work out what needs to be run on the source server and what on the destination server?
John
November 20, 2017 at 8:07 am
Thanks John. This is helpful. I haven't done this in the past so just wanted to ensure i follow correct steps.
November 20, 2017 at 8:08 am
dva2007 - Monday, November 20, 2017 7:25 AMI am working on migration project from 2005 to 2012. We have many SQL logins in current server which i assume are used in various applications. However nobody knows the password for many of them. If i dont know the password for those users what would be the best option to migrate them? One option is migrate login and then reset the password however this means all applications where this login has been used need to change. Another option is to migrate logins with original password. I was referring to this link but i was confused with second option when it refers to server A as destination server.I would be grateful with some guidance.
Vijay
You first run the scripts from the article on Server A which is your SQL Server 2005.
So on the 2005 server, you use that script to create two stored procedures - sp_hexadecimal and sp_help_revlogin
Then on the 2005 server, execute sp_help_revlogin and it will generate a script of the logins that you can use on the 2012 server. The SQL Logins will include the passwords so you can execute the statements and create the needed logins from the 2005 server on the 2012 server.
Sue
November 20, 2017 at 8:11 am
Perfect - All Done.
November 20, 2017 at 8:23 am
Works like a charm, every time.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply