I'm trying to set up a datasource in the cf administrator. I'm on WinXP Pro with CF 6.1 and MSSQL 2000.
Here's the error: Connection verification failed for data source: ventura []java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'vsw00\cf'. 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 'vswsp200\cf'. Reason: Not associated with a trusted SQL Server connection. I've tried lots of things ... set up a SQL Server group, created a user CF and assigned that user to that group. In Enterprise manager, I gave that user every conceivable permission I could find. If somebody is available to get on the phone with me and talk me through this, that might help ... send me your number privately and I'll call you back on my dime. E-mail: [EMAIL PROTECTED], or AIM: GoCatGo1956 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Howard Owens Internet Operations Cordinator Ventura County Star / E.W. Scripps Co. www.venturacountystar.com [EMAIL PROTECTED] AIM: GoCatGo1956 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137771 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
