Password Expired
Appears when you connect to a server with Microsoft SQL Server Management Studio using SQL Server Authentication, and the password you provided is correct but has expired. Also appears when you connect to a server with a new account that is created by using the User must change password at next logon option. Use the Password Expired dialog box to change the password for this SQL Server Authentication login.
Options
Login
Displays the SQL Server login that you are using.New Password
Type the new password for the login.Confirm Password
Type the new password again to confirm the typing.