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]

