Login

• Nita Reddy

  SSCarpal Tunnel

  Points: 4182

  More actions

  July 13, 2007 at 11:46 am

  #117773

  How Can I transfer Login from SQL 2000 to SQL 2005?

  Nita

• DeirdreBachman

  Mr or Mrs. 500

  Points: 526

  More actions

  July 13, 2007 at 1:12 pm

  #719408

  I believe DTS/SSIS has a login transfer task - http://technet.microsoft.com/en-us/library/ms137870.aspx

  -- http://dbachman.blogspot.com

• Adrienne250

  Right there with Babe

  Points: 737

  More actions

  July 13, 2007 at 2:33 pm

  #719422

  I used the scripts found here

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

  under the heading  -- A complete resolution to transfer logins and passwords between different versions of SQL Server.

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 16, 2007 at 1:59 am

  #719576

  THERE IS  a script available in microsoft site named sp_help_revlogin that can be used to transfer the logins from 2000 to 2005 servers.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• noeld

  SSC Guru

  Points: 96590

  More actions

  July 16, 2007 at 10:40 am

  #719742

  It just happens to be the one posted above you

  
  * Noel