?
Solved

Error connecting Coldfusion MSSQL DB

Posted on 2008-10-06
1
Medium Priority
?
661 Views
Last Modified: 2013-12-24
Hello experts.
I'm trying to add a new Datasource in CF8 but i have the error:
Connection verification failed for data source: carfree24
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect

Also  TCP/IP is enabled and the port is 1433 but when i want to test the connection in cmd:
telnet localhost 1433 i get connection failed
(I have CF8 and MSSQL 2000)
Any help?
0
Comment
Question by:Panos
1 Comment
 
LVL 2

Accepted Solution

by:
Panos earned 0 total points
ID: 22648772
The solution is to update the MS SQL 2000 with sp4.
(this did work for me)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question