Skip to main content
April 4, 2007
Question

MS SQL Connection problems

  • April 4, 2007
  • 1 reply
  • 291 views
I'm using the latest version of ColdFusionMX7 and MS SQL 2000 version 8.0. I have set it up on one computer just fine. I want another instalation to work on so I installed the same software again. Everything looks OK but when I try to make a connection to any SQL database I get an error:

Connection verification failed for data source: feedtrader
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect

I can connect to an Access database but never to an SQL database. What is confusing is that it works just fine on my other computer. I have tried different accounts, complex passwords, reinstalling both SQL and ColdFusion and nothing helps. What I'm I missing?

Any sugestions??
This topic has been closed for replies.

1 reply

April 6, 2007
Problem solved.
Participant
April 25, 2007
I'm having the same exact issue, what did you do to solve it?