Moving SQL 2000 logins to SQL 2005

• Samantha Colquhoun

  SSC Veteran

  Points: 215

  More actions

  July 26, 2007 at 1:10 am

  #177681

  I'm having a problem moving my 2000 logins to 2005. I'm using 'sp_help_revlogin'

  as described in the Microsoft article ID: 246133. A few of the logins have moved across without a problem but most are coming up with the error

  Msg 15021, Level 16, State 2, Line 1

  Invalid value given for parameter PASSWORD. Specify a valid parameter value.

  below is one of of the failed logins  

  SET @pwd = CONVERT (varbinary(256), 0x01003256AB49FFC4CD3AA799F0EFF6EE07FA6F7F9CDF38AA818F48F5BCF7)

   

  Any Ideas?

   

  Thanks

• bledu

  SSChampion

  Points: 12335

  More actions

  July 26, 2007 at 2:56 am

  #722501

  did you try

  CREATE

  LOGIN [someUser] WITH PASSWORD = passwordHash HASHED

  ---

  Everything you can imagine is real.
  

• steve block

  SSCertifiable

  Points: 7698

  More actions

  August 1, 2007 at 9:48 am

  #723934

  There is a seperate sp_help_revlogin for moving 2000 to 2000 from moving 2000 to 2005.  Are you using the one for 2005?

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

  Steve

• Rich Hansell

  SSCrazy

  Points: 2346

  More actions

  August 2, 2007 at 8:30 am

  #724200

  The correct one will render what was mentioned above:

  CREATE LOGIN [User] WITH PASSWORD=0x0100..5A5B11 HASHED, CHECK_POLICY=OFF, SID=0x199F..E19

  Which is what your looking for I beleive