After upgrading my development system from ColdFusion MX and MS SQL 2000 to ColdFusion 8 and MS SQL Express 2005 I was getting the dreaded SQLServer JDBC Driver errors. The fix is in the Adobe link below – custom config the TCP/IP settings. In my case I used the existing “Dynamic port”
1 2 3 4 5 | Connection verification failed for data source: {data source name} 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 |
http://kb.adobe.com/selfservice/viewContent.do?externalId=kb400255&sliceId=1
SQL 2005 TCP Settings
– Protocols for SQLEXPRESS
– Set “Enabled” to “Yes” For IP1 & IP2
– Note the port for IPALL
ColdFusion Datasource
– SQL Server Port
4 thoughts on “ColdFusion 8 Data Source with MS SQL Express 2005”
LOVE YOU! Saved my butt!
Hi DP – The port number to use for ColdFusion is from the MS SQL Express TCP/IP Properties. In my case that was 4718. If you’ve changed it as long as SQL and ColdFusion are the same that should still work.
Hi!
I have the sample error message as you got, and I put the port number that you have, I still get same error message, How can I identify port number on my computer?