Trying to reset a user password error

Question

Post reply

Trying to reset a user password error

Viewing 5 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

jrmtl Ten Centuries Points: 1075 More actions · Answer 1

I am trying to only reset a user's password so i can't put the old

This worked !

sp_password NULL, 'new_password', 'user'

How can i force the password to be changed at first login ?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

exec sp_password @new = 'password', @loginname = 'username'

jrmtl Ten Centuries Points: 1075 More actions · Answer 3

I had to put NULL for the old password parameter,

how can i force a change when the user logs in , the equivalent of MUST_CHANGE in sql2005

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

jrmtl (6/29/2009)
I had to put NULL for the old password parameter,
how can i force a change when the user logs in , the equivalent of MUST_CHANGE in sql2005

You can't.

jrmtl Ten Centuries Points: 1075 More actions · Answer 5

jrmtl

Ten Centuries

Points: 1075

June 29, 2009 at 11:33 am

#1017014

ok fair enough ...

Thanks a bunch for your help !

Trying to reset a user password error

Cookies on SQLServerCentral