Change password using sp_password

• gburcus

  Old Hand

  Points: 379

  More actions

  August 21, 2003 at 10:03 am

  #159579

  I tried to provide the user the possibility to change his password.

  I have written a stored procedure which call sp_password :

  EXEC master.dbo.sp_password @sOldPassword

  ,@sNewPassword

  ,@sLoginName

  I gave the execution rights to public roles for this stored procedure.

  I run the stored proc from SQL Query Analizer using my user name ( admin rights) and it works.

  I launch SQL Query Analizer using the user name and the new password.

  I try to change once again the password from the launched SQL Query Analizer using the user name and the new password and it doesn’t work.

  The error message is:

  Seuls les membres du rôle sysadmin peuvent utiliser l'option loginame. Le mot de passe n'a pas été changé.

  Someone has an idea how I can do that and why it doesn’t work

  I didn’t try to change somebody else password and Microsoft help says that I will be able to change my own password without admin rights.

  Thanks

  Gregoire

• Larry C

  Default port

  Points: 1493

  More actions

  August 21, 2003 at 12:11 pm

  #470839

  Try this: sp_password [ [ @old = ] 'old_password' , ]

  { [ @new =] 'new_password' }

  of course, you must be logged in with the name you wish to change.

• Dega

  Grasshopper

  Points: 17

  More actions

  September 4, 2003 at 3:33 am

  #472489

  sp_password cannot be executed within a user defined transaction. (Ref SQL Books online). You can exucute sp_password

  All the best

  DEGA