In my case, my password was reset. When connecting, I changed the Authentication to another option then back to "SQL Server Authentication". After it, when I hit "Connect" it asked me to update the password.