KB - SQLexpress / Smartcryptdb.exe - Login Failed when the credentials are correct
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.