Skip to main content
Known Participant
September 2, 2009
Answered

Help - CF no longer talking to SQL

  • September 2, 2009
  • 1 reply
  • 692 views

A bug with a Microsoft update timebombed my SQL Express installation making it "expired" (even though SQL Express doesn't expire).  The fix, I found was to uninstall SQL Express and reinstall.  After the reinstall, SQL worked again, but now CF will not talk to it.  When I go to create or verify existing datasources in the CF Admin page, I get:

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

Tried installing the JRun 4 Updater but that updater won't even run!  It asks to be pointed to the current dir for JRun (which does not exist on my machine).  When I point it to the dir where the existing JRun exe lives, it says it's not a valid JRun dir and aborts installation.

What's going on?  Before MS screwed me over with the update, everything was working fine!  Rolling the MS Update back is not an option.

Any help appreciated!

    This topic has been closed for replies.
    Correct answer JR__Bob__Dobbs-qSBHQ2

    I suspect that you'll need to configure SQL Express to accept TCP/IP connections and use SQL authentication.  Both are disabled in the default installation.

    See this blog post for more info.

    http://www.fusioncube.net/index.php/coldfusion-sql-server-express

    1 reply

    JR__Bob__Dobbs-qSBHQ2Correct answer
    Inspiring
    September 3, 2009

    I suspect that you'll need to configure SQL Express to accept TCP/IP connections and use SQL authentication.  Both are disabled in the default installation.

    See this blog post for more info.

    http://www.fusioncube.net/index.php/coldfusion-sql-server-express

    lerxst3Author
    Known Participant
    September 3, 2009

    Much thanks!