Cannot log into SQL Server Management Studio after changing the sa password.

Issue

After changing the sa password in SQL Server Management Studio, subsequent logon attempts fail.

Product Line

Andover Continuum, SmartStruxure Solution

Environment

SQL Server 2008

Cause

It appears that SSMS retains the last saved password in its cache when the Remember Password checkbox is selected, even when the new password is entered into the password field.

Resolution

Deselect the Remember Password checkbox and login to SSMS.