You must check the box "trusted" in the ODBC setup.
======================================
We can get rid of spam on your domain! , Anti-spam solutions
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
======================================
----- Original Message -----
From: Burns, John D
To: CF-Talk
Sent: Thursday, April 15, 2004 12:56 PM
Subject: Error adding CF Datasource
Ok, I just set up a new server with Windows 2k3 server. This is the
first go around I've had with working on W2k3. I installed MS SQL and
CFMX 6.1 on the server. I can connect to the SQL server fine through
enterprise manager and I set it up a windows user to use when connecting
to the sql databases. I went into the CF admin and set up a datasource.
When I submit the datasource, I get the following error:
Connection verification failed for data source: (mydatasource)
[]java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver][SQLServer]Login failed for user '(domain\cfuser)'. 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 '(domain\cfuser)'. Reason:
Not associated with a trusted SQL Server connection.
What I'm trying to figure out is whether this is a CF thing or a SQL
server thing or maybe some new default security lock-down in W2k3.
Please help! :-)
Thanks,
John Burns
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
