Skip to main content
Participating Frequently
May 10, 2007
Answered

TOTALLY TROUBLED With SQL Server 2005

  • May 10, 2007
  • 1 reply
  • 1013 views
Hi Everyone

I'm just installed the SQL Server 2005, i'm using Coldfusion MX 7.0.2 with all its hotfixes, and i'm still without any datasource connected to MSSQL2k5

I used the traditional way to create the datasource using the embeded driver of Microsoft SQL Server put the correct data on the fields and the message of error was this:

Connection verification failed for data source: recofoce21
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect


Then i read that Microsoft released a JDBC driver, i installed onto de Coldfusion has mentioned in this Tech note:

ENABLED http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=ded4216b

I create a new datasource as the example showed and NOTHING:

Connection verification failed for data source: redcofoce
com.microsoft.sqlserver.jdbc.SQLServerException: La conexión TCP/IP al host ha fallado. java.net.ConnectException: Connection refused: connect
The root cause was that: com.microsoft.sqlserver.jdbc.SQLServerException: La conexión TCP/IP al host ha fallado. java.net.ConnectException: Connection refused: connect




At other forums read that perhaps is the authentication type used, my authentication is "SQL Authentication" WTF!!!!!

My TCP/IP is enabled, VIA ENABLED, PIPE enabled too

Please give me a ray of light!!!!

This topic has been closed for replies.
Correct answer tzimmerman
Yes i read that

I had worked with SQL SERVER 2000 and CF MX 7 without any trouble. But still without connect to SQLSERVER 2005

One other thing you can do is verify that the database is listening on port 1433. Go into Network Configuration... on the General properties tab for the database. Select TCP/IP and click on Properties... button.

Ted Zimmerman

1 reply

Participating Frequently
May 10, 2007
One thing you can try is using the ip address of your server instead of the server name in the url for the database.

Ted Zimmerman
Inspiring
May 14, 2007
Hi Rodrix,

Have you read Robi Sen's this blog?
Participating Frequently
May 17, 2007
Yes i read that

I had worked with SQL SERVER 2000 and CF MX 7 without any trouble. But still without connect to SQLSERVER 2005