Error

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

Resolution

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

Demonstrating how to set both SQL and Windows auth