Answered
TOTALLY TROUBLED With SQL Server 2005
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!!!!
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!!!!
