MS SQL 2005 and 2008 deny ip Connections by default, you have to go into the settings (don't remember how off the top of my head) and allow tcpip connections.
-----Original Message----- From: Christopher Stowell [mailto:[email protected]] Sent: Friday, March 19, 2010 1:34 PM To: cf-talk Subject: CF9 and MS SQL DSN Creation Errors 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:331898 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
