Ok.. I've installed CF9 64bit and MS SQL 8 on my local machine which is running
Windows 7 Professional. The install for CF went fine and all 'initial' created
DSN's that came with the install verified fine. I am able to load the SQL
Manager and create databases/users with no problem. I created a DSN using the
stand alone ODBC manager on the computer and tested connection and works fine.
But the problem happens when I try creating a DSN within ColdFusion
Administrator. I create a new DSN (different name then the one in the ODBC
Manager), put in the database name, localhost for server (tried 127.0.0.1), and
the username, in this case is sa. No password since its a stand alone dev
machine. But I get the following error:
Connection verification failed for data source: WebSite001DSN
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC
Driver]Error establishing socket to host and port: localhost:1433. Reason:
Connection refused: connect
The root cause was that:
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC
Driver]Error establishing socket to host and port: localhost:1433.
Reason: Connection refused: connect
I tried creating a ODBC Socket connection within COldFusion Administrator but
tells me the ODBC Service is not running and when try starting the agent and
server both, they both start but shut back down isntantly.
Does anyone have any ideas? I did disable my firewall on that machine but it
did not help.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331897
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
