Found the answer on Stephen Crat's Talkingtree.com blog... can't have Windows only authentication for MSSQL JDBC driver in CFMX - have to set it up in mssql enterprise mgr to have windows and MSSQL security
-----Original Message----- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Friday, July 22, 2005 7:05 AM To: CF-Talk Subject: CFMX 7 - DSN - MSSQL Having a problem getting a MSSQL DSN setup in CFMX 7 (brand new install) I've tried various configurations and username/pw combinations... I'm logged in on this computer as the administrator of a w2k network domain and have entered that username/pw combo into the DSN settings and even tried the local administrator account but always getting this error: Connection verification failed for data source: project76 java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'domainname\administrator'. 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 'domainname\administrator'. Reason: Not associated with a trusted SQL Server connection. Any help would be appreciated Tim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212506 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54