• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Is SQL Server 2008 R2 compatible with CF9?

Guest
Mar 23, 2017 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

238

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
community guidelines
Advocate ,
Mar 23, 2017 Mar 23, 2017

Copy link to clipboard

Copied

LATEST

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.

Votes

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
community guidelines
Resources
Documentation