After restoring a database I got an error for the user not being able to log in even though the credentials were correct. The user was using SQL server log in method, so the solution was to enable logging into the database using SQL Server logins and not just the default Windows Authentication method.
Right click the SQL server -> Properties -> Security -> SQL Server and Windows Authentication mode -> Ok.
