Problem:

Why am I unable to connect to my database with the error: "user.. not associated with trusted SQL connection"?

Resolution:

When attempting to create a connection to the database or create a new database you may receive an error:

“User is not associated with a trusted SQL connection”

This occurs even of the correct login details are provided.

The cause of this issue is due to security settings set within the SQL database server itself.

Specifically there exists a permission violation for the user provided.

This can be resolved by adjusting the permission for the user to the correct level eg read or read/write access and setting the authentication mode of the server from “Windows” to “Mixed Mode”.