House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home / Groups / ColdFusion Talk (CF-Talk)

ColdFusion 9 and MS SQL DSN Creation Errors

Author:
DURETTE, STEVEN J (ATTASIAIT)
03/19/2010 01:37 PM

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. 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.       


Search cf-talk

February 11, 2012

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
       1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29