transfer sql logins

Posted on 2011-05-10
Last Modified: 2012-05-11
I need to migrate a database from sql server 2000 to sql server 2008 so I backuped this database and then restored it to sql server I need to transfer logins from sql server 2000 to sql server 2008 but to To my knowledge, Microsoft has not yet updated their Knowledge Base to inform administrators how to migrate SQL Server logins to SQL Server 2008..there is a article Method 2 of this Microsoft KB article details how to transfer a login from SQL 2000 to SQL 2005 but not sql server how can I transfer sql logins from sql server 2000 to sql server 2008?
Question by:teodor76
    LVL 4

    Assisted Solution

    Here you go .. let me know if this helped ????
    LVL 57

    Accepted Solution

    You can use the script provided here:

    Method 2 will work not only for SQL Server 2005 but also for SQL Server 2008 too
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Hi, you can do this using SSIS's Transfer Login Task. image

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now