Post reply

transfer a login with password from SQL 2012 to SQL 2008

  • April 14, 2015 at 1:07 pm

    #398328

    Hi, I need to transfer a login with password from SQL 2012 to SQL 2008. The problem is that the Hash value of passwords is different in 2012 than 2008, so I cannot create it in 2008.

  • April 14, 2015 at 1:40 pm

    #1790952

    I don't think there is a simple way to script out the login and back-port it to 2008 from 2012.

    Maybe I'm wrong and someone will correct me (please do), but you might just need to go old school and ask around for the password and manually set it on the 2008 server yourself. Surely someone has to know the password, right? :unsure: Either that or maybe just reset the password?

    Twitter: @SQL_JGood
    Blog: sqljgood.wordpress.com/[/url]

  • April 15, 2015 at 5:10 am

    #1791047

    is it not an option to just reset the password

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • April 15, 2015 at 6:21 am

    #1791064

    No.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply