Highlighted

Is SQL Server 2008 R2 compatible with CF9?

New Here ,
Mar 23, 2017

Copy link to clipboard

Copied

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

Views

128

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Is SQL Server 2008 R2 compatible with CF9?

New Here ,
Mar 23, 2017

Copy link to clipboard

Copied

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

Views

129

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Mar 23, 2017 0
Advocate ,
Mar 23, 2017

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 23, 2017 0