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
I got it works now,
Thanks for helping and informaiton,
Regards,
Iccsi,
Copy link to clipboard
Copied
I got it works now,
Thanks for helping and informaiton,
Regards,
Iccsi,
Copy link to clipboard
Copied
Please, kindly say how you solved the problem. It will help someone else in future.
Copy link to clipboard
Copied
Thanks for the message,
It was my mistake a typo on the server name.
Thanks again for helping and message,
Regards,
Iccsi,