Error

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

Resolution

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