locked
Migrate Logins from SQL 2000 to SQL 2008 R2 RRS feed

  • Question

  • Hi experts!

    How to copy users from Security-> Logins from one SQL 2008 R2 to another SQL 2008 R2?

    I'm newbie in this:)

    Friday, October 8, 2010 5:34 PM

Answers

  • try ...

    http://support.microsoft.com/kb/246133

    However you will most likely have to reset the password for ALL sql logins as the hashing have changed between 2000 and 2008.


    Thanks. Mohit. -------------------------------------- MCTS: SQL Server 2005, MCITP: Database Administrator. http://sqllearnings.blogspot.com/
    • Proposed as answer by Tom Li - MSFT Tuesday, October 12, 2010 11:28 AM
    • Marked as answer by Tom Li - MSFT Sunday, October 17, 2010 9:01 AM
    Friday, October 8, 2010 10:06 PM