CF10 to SQL 2005 works for me. That is an odd error you get. If I change CF10 datasource to "wrong" user or password I get different error:
Connection verification failed for data source: "DSN"
java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'wrong'.The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'wrong'.
Perhaps details in coldfusion-out.log from ColdFusion10\cfusion\logs will have some details that will lead to a solution?
Thanks Carl, I can give your error info to our IT people, maybe it will help. I suspect it is an error in the two servers connecting to each other.
When I looked at the log, I get different errors depending on if I put in a valid user or a valid password.
Here is a different variation
Jan 6, 2014 12:51:49 PM Error [ajp-bio-8012-exec-3] - [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'xxxx_user'. Reason: The password of the account must be changed.
OK, now I feel silly. Even though the force user to change password was not selected, it was still forcing me to change the password. I did and it looks like it can connect now.