Looking to upgrade our CF11 application to CF21 or CF23. We're running on linux and the database is MSSQL2014. Looking at the support matrix, I see that CF21 support MS SQL 2014, but, CF23 looks to only support MS SQL 2019 and later. Upgrading MSSQL isn't in the cards as we own our license and that would be a very expensive update. Key Note: We're not using the internal CF drivers, we're using JDBC drivers from MS to support HFA with MultiSubnetFailover=True

If you are using JDBC couldn’t you simply find an older driver which supports your sql server edition?

Didn't Microsoft end support for both MSSQL'14 and the JDBC driver like 3-4 years ago? I'm seeing a ton of unresolved CVE's that are 9+ that you might want to think about.

JDBC is still valid. Latest version EOL is July 31, 2028 As for upgrading MSSQL'14 to new version, We're running a large enterprise setup with lots of $$$$$$ invested in the licences and we're not interested in doing an upgrade with that at this time. I need to do some testing with the latest JDBC to see if it'll still work with older versions. I was just wondering why CF23 would care about it.. I thought for the most part that stuff was backwards compatible.

Ok, I thought the latest JDBC didn't have compatibility with MSSQL 2014. Maybe that was only if you enabled encryption

@billy If you are using JDBC driver that supports MSSQL2014 that it will not be an issue however, Adobe will not support if you encounter any issue that is related to the DB. I am hopeful that the ColdFusion built-in drivers will also work with this version of SQL but we did not test this version so it will be difficult to support it. BTW, ColdFusion 2021/2023 driver doesn't support MultiSubnetFailover - https://coldfusion.adobe.com/2023/03/configuring-multisubnetfailover-for-microsoft-sql-connection-string-in-coldfusion/

The only issue I've had with DB is while using the JDBC, query results doesn't return the correct number of records updated while using cfqueryparam. Not a show stopper.