> *exactly* like I do at work...it's just my home machine, and
> I'm trying to get a datasource up and running. I've updated
> CFMX, the works...but for some reason, I get the following
> error...anything look familiar here that's just a quick fix?
>
> Connection verification failed for data source: JeffSQL
> []java.sql.SQLException: [Macromedia][SQLServer JDBC
> Driver][SQLServer]Login failed for user 'Jeff Small'. 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 'Jeff Small'. Reason: Not associated with a trusted
> SQL Server connection.
The CF Administrator datasource settings for MS SQL Server don't allow the
use of trusted connections. You'll need to create a native SQL login within
your database (as opposed to a Windows account) and use that from CF. You
may also need to configure your SQL Server to allow both Windows and native
SQL logins ("mixed mode" authentication) instead of just Windows
authentication.
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]
