Forum Discussion
trac1234
17 years agoNew Contributor
Common error messages that may occur when you try to connect to your SQL server:
java.sql.SQLException: [Microsoft][SQLServer Driver for JDBC][SQLServer]Login failed for user 'user'. Reason: Not associated with a trusted SQL Server connection.
This error message occurs if the SQL Server authentication mode is set to Windows Authentication mode. The Microsoft SQL Server driver for JDBC does not support connecting by using Windows NT authentication. You must set the authentication mode of your SQL Server to Mixed mode, which permits both Windows Authentication and SQL Server Authentication.
java.sql.SQLException: [Microsoft][SQLServer Driver for JDBC][SQLServer]Login failed for user 'user'. Reason: Not associated with a trusted SQL Server connection.
This error message occurs if the SQL Server authentication mode is set to Windows Authentication mode. The Microsoft SQL Server driver for JDBC does not support connecting by using Windows NT authentication. You must set the authentication mode of your SQL Server to Mixed mode, which permits both Windows Authentication and SQL Server Authentication.