> 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! :-)
By default, SQL Server 2000 only accepts trusted connections, which use
Windows authentication. To use SQL Server from CFMX using the JDBC drivers,
you'll need to enable native SQL logins within your SQL Server.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
