Click for larger image.  SQL Server Authentication Configuration

When attempting to establish a SQL Server datasource from ColdFusion MX 6.1 while using the default JDBC driver (DataDirect 3.2) for Microsoft SQL Server, you may encounter the following error message if the database security on the database itself is configured to permit "Windows only" authentication:





Connection verification failed for data source: foo
[]java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]
Login failed for user 'foouser'.
Reason: Not associated with a trusted SQL Server connection.
The root cause was that: java.sql.SQLException:
[Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'foouser'.
Reason: Not associated with a trusted SQL Server connection.


Setting the database authentication to "Windows only" requires the use of a driver capable of a "Trusted Connection". This type of connection automatically sends Windows user account login as the authentication credentials to the database rather than using a provided username and password. ColdFusion MX 6.1 does not yet support trusted connections while using the available JDBC drivers and cannot connect to databases requiring trusted connections. To permit CFMX to connect to the database using the SQL Server JDBC driver, configure the database authenication to permit "SQL Server and Windows", as shown in the image here. Then provide a valid user name and password in the CFMX datasource configuration page for that dsn.