Hey all -
I'm maintaining a 10.2 installation (AIX not Windows) for a client that's decomming in another year but they want to move the existing SQL server instance that currently hosts the CS to Azure SQL Server 2022. Only the CS and audit DBs will be hosted there, not reporting data sources.
When the CS connection is created in Cogconfig, it successfully connects the first time but then times out thereafter. We think it could be either TLS related, driver, or perhaps SSL cert issue since we have to use SSL option set to true to connect.
Has anyone either successfully connected to Azure or SQL Server 2022? I know it uses JDBC to connect in CogConfig, and we've tried a few solutions from some old KB articles (such as setting overrideDefaultTLS=true -- although this isn't obvious where to set it in Linux) to no avail.
Cheers.
Ummm... good luck?
The Cognos Business Intelligence 10.2.1 Supported Software Environments (http://|https://www.ibm.com/support/pages/cognos-business-intelligence-1021-supported-software-environments) system has mostly broken links. I'm thinking that Azure SQL 2022 may not be in the compatibility list for a system for which support ended about seven years ago. Maybe suggest running SQL Server 2012 on Windows Server 2012R2 on an Azure VM.
Haha, thanks. Funnily enough I said the same thing to them.
I think I tracked the issue to the JSQLConnect driver which is bundled with Cognos, which doesn't support '22. I'm going to see if I can upgrade this driver directly but not holding my breath as I'm guessing it's a separate licensed product just for Cognos.
All their SQL envs are moving to '22 so an earlier version is not on the table. Looks like they'll have to throw it on Oracle/DB2!
Thanks.