Datasource failure

Question

I have a CF8 developer installation on a RHEL5 machine

and MS SQL 2005 on Windows Server 2003

When trying to create a datasource in CF Administrator I get one of two errors:

If I provide a username and password in the connection dialog box:

The root cause was that java.sql.SQLException...user is not associated with a trusted SQL Server Connection

If I don't use a username/password it tells me:

Username not specified and the driver could not establish a connection using Kerberos (type4) integrated security.

The root cause was that java.sql.SQLException... no login modules configured for JDBC_DRIVER_01

I can connect to MSSQL on my production instance of CF which is installed on the same box as SQL Server. If I can not get a development box set up I can not see the databases in Dreamweaver. I feel like I am running in circles.

BKBK · Answer

If I provide a username and password in the connection dialog box:
The root cause was that java.sql.SQLException...user is not associated with a trusted SQL Server Connection

That sounds like a well-known MS SQL authentication problem. You have to change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded