Add the following parameters to the : -Duser.language=en -Duser.region=US Use code with caution. Save your settings and restart the Cognos service. 3. Missing or Mismatched SSL/TLS Certificates
Execute a network reachability test using the specific database port (e.g., 1433 for SQL Server, 50000 for Db2, or 1521 for Oracle):
Confirm that the JDBC driver in the installation folder matches the database version.
: Obtain the database server's public .crt or .pem file. Import it directly into the Cognos Keystore ( cacerts ) using the Java keytool utility: Add the following parameters to the : -Duser
Navigate to cognos_install/location/bin/jdbc/ . Ensure the correct driver JAR is present. For example:
5. Account Expiration and Single Sign-On (SSO) Incompatibilities
Ensure the correct JDBC driver for your database type (DB2, Oracle, SQL Server, Snowflake, etc.) is in the . Missing or Mismatched SSL/TLS Certificates Execute a network
Example diagnostic timeline (concise)
Ensure the reporting server can actually "see" the database server over the network.
If you suspect a version conflict (common with Db2 or Snowflake), try using the specific driver version recommended by IBM Support for your version of Cognos. Ensure the correct driver JAR is present
Navigate to -> Configuration -> Data Source Connections .
When to call for escalation
: SQL Server is not configured to allow remote TCP/IP connections.