• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

transfer sql logins

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?
0
teodor76
Asked:
teodor76
2 Solutions
 
qasim_mdCommented:
Here you go .. let me know if this helped ????

http://support.microsoft.com/kb/918992
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
You can use the script provided here:

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

Method 2 will work not only for SQL Server 2005 but also for SQL Server 2008 too
0
 
Alpesh PatelAssistant ConsultantCommented:
Hi, you can do this using SSIS's Transfer Login Task. image
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now