Post reply

Transfer Logins from SQL Server 2005 to SQL Server 2008 different server

  • October 13, 2009 at 3:46 pm

    #227010

    How to transfer logins and passwords between instances of SQL Server

    http://support.microsoft.com/kb/918992/[/url]

    Does not list that it works on SQL Server 2008

    The script and procedure to transfer users from SQL 2005 to SQL 2005 on a different server looks great. Has anyone had experience using this for SQL Server 2008?

    Production Server Windows 2003- SQL Server 2005 - CompanyDomain

    Test Server Windows 2003 - SQL Server 2008 - CompanyDomain (i.e. Same Domain)

    After running SQL Server 2008 Upgrade Advisor:

    Full backup of Production Server DBs SQL 2005

    Restore on Test Server DBs SQL Server 2008

    As expected - Logins are on Database / Security / Users

    But, missing on SQLServer/Security/Logins

    During our test phase - this process may be run several times.

    Then for the final SQL Server 2008 location - a proven script would be wonderful.

  • October 13, 2009 at 6:08 pm

    #1065454

    I used this for copying from SQL 2008 -> 2008. It should work 2005 -> 2008.

    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

  • October 15, 2009 at 2:14 pm

    #1066515

    Status:

    Just ran the script on a SQL Server 2005 to create the SP described.

    One noted difference from the instructions at Microsoft.

    MS implies to run Enterprise manager from Server A.

    I ran SQL Server 2008 Enterprise Manager from my workstation.

    After running the SP, it generates a nice script.

    Commented out some user names for databases that are not being migrated to server B.

    Copied and ran the output scrip from my workstation against Server B.

    Server B is running SQL Server 2008.

    It all looks good so far. Will continue testing and post if I find any problems.

    Thanks for the input.

  • January 11, 2010 at 6:56 pm

    #1102134

    Wayne,

    I don't see what it is you used to transfer the l?ogins

  • January 11, 2010 at 11:33 pm

    #1102193

    The scripts included the logon.

    One logon and password were not know to me, and there was some encoded part of the script that created it.

    the trick is to run the script to create a script.

    Then run the created script on the 2008 server.

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

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