Skip to main content
C
ctreeves
Inspiring
January 6, 2014
Question

Connect CF10 to MS SQL 2005?

  • January 6, 2014
  • 1 reply
  • 823 views

Can I connect CF10 to MS SQL 2005?

No matter what I try I get errors.  The application is on a different box the SQL.

I tried creating a user and a password and I get this error:

Connection verification failed for data source: xxxxxxxxx

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'xxxxxxxxxxx'. Reason: The password of the account must be changed.

The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'xxxxxxxxxx'. Reason: The password of the account must be changed.

I tried changing the password, but that didn't work either.

I'm not a programmer, so please be gentle with your answers.

Thanks

    This topic has been closed for replies.

    1 reply

    C
    carl type3
    Legend
    January 7, 2014

    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?

    HTH, Carl.

    C
    ctreevesAuthor
    Inspiring
    January 7, 2014

    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.

    C
    ctreevesAuthor
    Inspiring
    January 7, 2014

    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.

    Firefly Community Gallery
    Adobe Firefly

    Remix with Firefly Community Gallery

    Thousands of free creations to fall in love with and remix in Firefly.

    Explore now
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices