Login Failed for user when  you know the credentials are correct using SQLexpress and credentials for the SQL Database.

Failed sql login with correct credentials


Edit the SQL server properties to allow both SQL server and Windows Authentication mode.

Demonstrating how to set both SQL and Windows auth