Admin? I checked the Windows Data Source and it tests correctly. When
I go through CF Admin, I choose SQL from the drop-down for database
types. I don't see a trusted option in there. I tried setting it up as
an ODBC connection and choosing the Windows Data Source and it worked
when I checked the trusted connection. But how do I get the normal "SQL
Server" option to work from the drop down. I've never had problems with
it in the past.
John
-----Original Message-----
From: Doug White [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 2:36 PM
To: CF-Talk
Subject: Re: Error adding CF Datasource
If you are running the SQL server on the same box, it is a SQL server
thing.
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]
