3 Replies Latest reply on Jan 7, 2014 5:19 AM by ctreeves

    Connect CF10 to MS SQL 2005?

    ctreeves

      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

        • 1. Re: Connect CF10 to MS SQL 2005?
          carl type3 Level 4

          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.

          • 2. Re: Connect CF10 to MS SQL 2005?
            ctreeves Level 1

            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.

            • 3. Re: Connect CF10 to MS SQL 2005?
              ctreeves Level 1

              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.