Solution: In SQL Server Management Studios, go to the database and reset the user’s password. Simple.