I don't know if it's specifically relevant or not to this thread, but I solved my issue. As I described in a different thread on the subject, I had created a SQL user and had declared a specific database as the default database in SQL Server 2005. However, I needed to specifically add that user to the database as well. So it was a two-step process: 1) create user account (and, optionally, assign default database); 2) specifically add that user to any database you wish to access from CF. Maybe everybody already knew that, but i don't remember needing the second step in SQL Server 2000. Hope it helps somebody.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289224 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
