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