Login failed--password of account must be changed--error 18488

I failed to connect to a production SQL server. My administrator reset my password, and told me what it was.

SQL Server Management Studio gives me this error: Login failed for user 'Bill'. Reason: The password of the account must be changed. (Microsoft SQL Server, Error: 18488)

So, how can I reset my password?

I tried terminaling into the server with this account, but it said that account doesn't exist. So I guess it's not a regular server account--just SQL server. (if that helps)

Solution 1:

If SSMS isn't prompting you to change your password, have the DBA remove the change password requirement, and give you instructions on how to change your password via the sp_password system stored procedure.

Solution 2:

In Security/Logins/[your user], Properties: Uncheck the option Enforce password policity, this should solve the problem.