• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Add MS SQL datasource error

Engaged ,
Dec 01, 2012 Dec 01, 2012

Copy link to clipboard

Copied

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

Views

670

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Engaged , Dec 01, 2012 Dec 01, 2012

I got it works now,

Thanks for helping and informaiton,

Regards,

Iccsi,

Votes

Translate

Translate
Engaged ,
Dec 01, 2012 Dec 01, 2012

Copy link to clipboard

Copied

I got it works now,

Thanks for helping and informaiton,

Regards,

Iccsi,

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Dec 02, 2012 Dec 02, 2012

Copy link to clipboard

Copied

Please, kindly say how you solved the problem. It will help someone else in future.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Dec 02, 2012 Dec 02, 2012

Copy link to clipboard

Copied

LATEST

Thanks for the message,

It was my mistake a typo on the server name.

Thanks again for helping and message,

Regards,

Iccsi,

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation