import/export users

• Chinna-703814

  SSC Enthusiast

  Points: 133

  More actions

  April 24, 2009 at 2:04 am

  #133414

  we have 100 sql server logins in sql 2000

  we are migrating from sql server 2000 to sql server 2005

  how do i export the logins to sql server 2005 database

  does the passwords are valid in the sql server 2005

  i need to export all logins to 2005 rather than creating one by one

  its mere urgent

  please some one help me out

  regards

• SQL_DBA_3

  SSCarpal Tunnel

  Points: 4770

  More actions

  April 24, 2009 at 2:12 am

  #983407

  Script out the logins and execute the script in 2005 master database.

• manoj2001

  SSCrazy

  Points: 2225

  More actions

  April 24, 2009 at 4:14 am

  #983440

  by using Transfer Logins Task package

  and sp_change_users_login

  Manoj

• Rajesh kasturi

  SSCarpal Tunnel

  Points: 4007

  More actions

  April 24, 2009 at 6:26 am

  #983479

  To transfer Windows and SQL Server Logins use the sp sp_help_revlogin

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

  Rajesh Kasturi