0

I'm connecting to a remote database using HeidiSQL client but looks like the administrator has activated the enforce password change policy (Error 18488).

Is there a workaround to solve this with HeidiSQL? Or I need to download and install SQL Server Management Studio?

1 Answer 1

1

You can change the password from sqlcmd using -z or -Z:

-z new_password Change password:

sqlcmd -U someuser -P s0mep@ssword -z a_new_p@a$$w0rd

-Z new_password Change password and exit:

sqlcmd -U someuser -P s0mep@ssword -Z a_new_p@a$$w0rd

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.