Help - CF no longer talking to SQL
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!
