This article helped me to solve my problems Thanks. If you do not see these settings in the Admin Console, please open a support case for Flexera support to assist with getting access to these settings.įor more information on this issue, you can refer to the following IBM KB: Connection to SQL Server fails when the server is configured to use TLS 1.2 or connecting to SQL Server 2016 If you are not seeing any of the data in the reports or widgets loading, you may need to take some additional steps to set a JVM argument for the QueryService to use TLS. This should now be successfulĪfter these steps the test connection should be successful and the Cognos services can be started, the FNMS Analytics should now be accessible.
Right click on Content Store and choose “Test”. 
In “IBM Cognos Configuration”, go to Data Access > Content Manager > Content Store. Start "IBM Cognos Configuration" using cogconfig.bat you modified in the previous step. Important: You must start "IBM Cognos Configuration" using cogconfig.bat. Locate cogconfig.bat, open this in a text editor and find the following line:. Locate bootstrap_wlp_os_version.xml, open this in a text editor and find the following line: -Xscmaxaot4m. Locate startwlp.bat, open this in a text editor and find the following line:. Open the bin64 folder under the Cognos installation directory, by default this will be: C:\Program Files\ibm\cognos\analytics\bin64. Once these steps are completed, you'll want to close the “IBM Cognos Configuration” utility. In here you'll want click edit on “SSL Protocols” and set this to only TLS 1.2, as seen in this screenshot:Īfter this, you'll need to go into Security > Cryptography > Cognos, click edit on “Supported ciphersuites” and add all of the ciphersuites that have “SHA256,” as seen in this screenshot: The first will be Security > Cryptography. This'll be done in the “IBM Cognos Configuration” utility. Next, you will need to add the SHA256 ciphersuites. By default, this location will be: C:\Program Files\ibm\cognos\analytics\jre\lib\security 
Once downloaded, they files will need to be extracted under the Cognos installation location to be installed. 
Note: You will be required to create an IBM login to download these files Get and install the Unrestricted SDK JCE policy files.Solution: The following steps can be taken to configure Cognos to communicate only via TLS 1.2: The connection has been closed."ĭiagnosis: If your SQL Server is configured to only communicate via TLS 1.2, you will see connection errors until a few additional steps are taken to configure Cognos to support only TLS 1.2.
Symptoms: When trying to connect Cognos to your SQL Server, you may see an error like:Įrror: "SQL Server did not return a response.
0 kommentar(er)
