Post reply

Move logins between SQL Server 2005 instance to SQL Server 2008 instance

  • June 24, 2010 at 11:14 am

    #234247

    Hi,

    I'm upgrading SQL Server 2005 to SQL Server 2008 using side-by-side upgrade method and trying to move the logins from 2005 instance to 2008 instance

    I did find the links to move logins fron 2000 to 2005, between 2005 instances and between 2008 instances from the below links.

    But I did NOT find a link to move logins between SQL Server 2005 instance to SQL Server 2008 instance

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

    How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008

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

    How to transfer logins and passwords between instances of SQL Server

    Method1:

    * You transfer logins and passwords from SQL Server 7.0 to SQL Server 7.0.

    * You transfer logins and passwords from SQL Server 7.0 to SQL Server 2000.

    * You transfer logins and passwords between servers that are running SQL Server 2000.

    Method2:

    * You transfer logins and passwords from SQL Server 7.0 to SQL Server 2005.

    * You transfer logins and passwords from SQL Server 2000 to SQL Server 2005.

    * You assign logins to roles.

    Please advice how to move logins between SQL Server 2005 instance to SQL Server 2008 instance?

    Thanks

  • June 24, 2010 at 12:33 pm

    #1184650

    In the first link you referenced is this

    Note This information also applies to SQL Server 2008.

    So, just use the sp_help_revlogin procedure to script them out, and then run the script to apply them.

    You can also fire up SSIS, and use the Transfer Logins task to do the same thing. Ensure you select the options to keep the SID and transfer a hashed password.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

Viewing 2 posts - 1 through 1 (of 1 total)

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