I got a reply from someone on the coldfusion macromedia forums yesterday and he asked me to refer to this url:
http://www.macromedia.com/support/coldfusion/ts/documents/tn18245.htm
I thought I'll share my experience with you all.. I'm sure a few people out there would be interested in hearing what I captured so here it goes.
Step 1: I configured an ODBC data source using the ODBC Driver Manager on the pc/server where ColdFusion is installed. In the ODBC Deriver Manager, I selected the sql server from the drop-down (Note: The SQL server we have running sits on its own box). I then clicked on 'Next' and tick the "with Windows NT authentication using the Network ID" radio button for the "how should sql server verify the authenticty of the login ID" section. On the last step I clicked on the "Test Data Source" button and it came back with "TESTS COMPLETED SUCCESSFULLY!".
No problems at all.
Step 2: In ColdFusion Administrator, I created a new datasource with "ODBC Socket" driver option selected. I selected the ODBC DSN creted in the previous step, ticked the "Trusted Connection" checkbox, left the username and password fields blank and clicked "Submit."
I got the following error message,
Connection verification failed for data source: DB_PRODUCTION
[]java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'REGIONAL\SATURN6$'.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'REGIONAL\SATURN6$'.
'REGIONAL\SATURN6$' is the machine account on the box where coldfusion is installed. I gave this account permission to access the database on the sql server and wholla, it worked.
Hope this helps
Thanks again
cfcoder
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
