The server may have been configured for integrated security only.
Change it to allow both SQL authentication and Windows Authentication by logging in using Windows user, then right click the server => Properties => Security, then change authentication mode to allow SQL authentication.
Then restart SQL server services.
Source: https://dba.stackexchange.com/questions/87390/sql-server-authentication-login-failed