Harold, Check your CFQuery code... I'd say you (or whoever) has added a "username" and "passoword" attribute. If you store the username and password in cf admin you can delete it from the cfquery code.
-mark -----Original Message----- From: Harold Brauer [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 10:34 AM To: CF-Talk Subject: CFClientStorage Getting the following error when I try to run a script where the DB is in SQL2K Operation failed on the data source named "CFClientStorage". Reason of failure "SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'." When I went into the admin the datasource was verified and when I went into the ODBC Data Source to set it up, it was successfully tested. Can anyone help me out with this? Hopefully it will be the last step in what has been a very long process of updating. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
