Take a look at the name of the database under option "Default database" in the properties of the LOGIN. This database is probably deleted or offline or the user doesn't have access to that database.

Correct the issue with the database or change the name to a database that is accessible for this login.