Is SQL Server 2008 R2 compatible with CF9?

[Guest]

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

[Steve Sommers]

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.