transfer sql logins

Posted on 2011-05-10
Medium Priority
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 2008..now 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 2008..so how can I transfer sql logins from sql server 2000 to sql server 2008?
Question by:teodor76

Assisted Solution

qasim_md earned 800 total points
ID: 35727248
Here you go .. let me know if this helped ????

LVL 57

Accepted Solution

Raja Jegan R earned 1200 total points
ID: 35727250
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
ID: 35727400
Hi, you can do this using SSIS's Transfer Login Task. image

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

850 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