Skip to main content
A
Anonymous
March 23, 2017
Question

Is SQL Server 2008 R2 compatible with CF9?

  • March 23, 2017
  • 1 reply
  • 315 views

Hello,

We got a message from out IT department that our SQL Server 2000 databases will get decommissioned. They wanted us to migrate to 2014, but according to the CF9 support matrix https://www.adobe.com/content/dam/Adobe/en/products/coldfusion/pdfs/coldfusion9-support-matrix-4-ue.pdf, CF9 is compatible only up to 2008.

So they created a 2008 R2 database server, but when I'm trying to connect to it through the CF9 admin screen I get the following:

Connection verification failed for data source: test

java.sql.SQLException: Timed out trying to establish connection

The root cause was that: java.sql.SQLException: Timed out trying to establish connection

I have no idea what's going on and I'm looking for help. Does it seems like a problem with a firewall? Not sure. Any help is appreciated. Thank you.

Edwin

This topic has been closed for replies.

1 reply

S
Steve Sommers
Legend
March 23, 2017

2008 R2, yes. I'm 99% certain it also is compatible with 2014 because I think we used it in that configuration.

The failure you are seeing is that is that since MS-SQL2005 TCP/IP connectivity (which CF uses) is disabled by default. You need to enable TCP/IP connectivity in the MS-SQL configuration.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices