3 Replies Latest reply on Dec 2, 2012 5:44 AM by iccsi

    Add MS SQL datasource error

    iccsi Level 1

      I just installed CF 10 on my Win 7 Home machine and tried to add a MS SQL server data source and got following error.

      do I need install any driver to add MS SQL Server as a data source?

      I am able to add MySQL database, but not MS SQL Server.

       

      Your help and information is great appreciated,

       

      Regards,

       

      iccsi,

       

      Connection verification failed for data source: MyServer

      java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: MyServer:1433. Reason: Connection refused: connect

      The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: MyServer:1433. Reason: Connection refused: connect