Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to transfer dynamically logins from SQL Server 2012 to SQL Server 2008 and I can't because when I get the hashed password on 2012 does not have a valid format to be used on 2008. I know that SQL Server change its legacy of hashing on 2012. So that the hash is bigger than those of 2008.

Is there a way to perform this?


share|improve this question

migrated from Sep 18 '13 at 18:51

This question came from our site for professional and enthusiast programmers.

@nlareu why do you have to do a reverse - migrate from 2012 to 2008 ? – Kin Sep 18 '13 at 19:09
I am building a user administration interface across multiple sql servers. I have to support SQL Server 2008 and 2012. The system must create the logins on the server where is installed and then clone them to another servers added. A possible use case is install it on a SQL Server 2012 and add another server with 2008. This is the only use case with problems. The other combinations work fine. – nlareu Sep 18 '13 at 19:52
I have not tried it, but does not sp_help_revlogin ( not helpful ? – Kin Sep 18 '13 at 19:55
I tried but when you run it on SQL Server 2012 the password hashed is too long and invalid for SQL Server 2008 because the legacy of password hashing has changed on 2012. But works if the case is 2008 to 2012, 2008 to 2008 and 2012 to 2012. – nlareu Sep 18 '13 at 20:17
Could you not install your user admin interface on 2008 and then you'll always have 2008 passwords. – Piers Karsenbarg Sep 19 '13 at 13:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.