Cognos 11.0.7
Windows Server 2012 R2
IIS
SQL Server 2016
Cognos 11.0.7 was running fine. I installed 11.0.13 to the same location where 11.0.7 was installed.
I saw the post for Upgrade issue from cognos 11.0.9 to 11.0.13 (https://www.cognoise.com/index.php/topic,35090.0.html)
I got the same error, but it was the last error in my startup.
QuoteIt works for me : http://cogknowhow.tm1.dk/archives/1567 (Renew the keys)
Only worked in the sense that I don't get that specific error any more.
When I test my data sources, I get...
[Logging]
[ ERROR ] IPFTEST-006 Logging failed to connect to Database:jdbc:sqlserver://SERVERNAME\INSTANCE;databaseName=IBMCognosAudit;integratedSecurity=true[Content Manager database connection]
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.I found that the install process deleted by JDBC auth files (sqljdbc_auth.dll for x86 and x64). Putting them back in the right place did not resolve the problem.
sqljdbc42.jar was still in the drivers folder.
The IBM Cognos service is configured to run as a MSAD service account. I have verified that the service account has all the necessary permissions for both databases. (The account has exactly the same permissions to the databases that it had when I began the install process -- when 11.0.7 was working.
When I try to start the service, I get...
CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.
CM-SYS-5003 Content Manager is unable to connect to the content store.
Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.
Cause: The connection to the host SERVERNAME, named instance INSTANCE failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.cogaudit.log is telling me that the logging service and the content manager service started successfully, then in the next few entries tells me it can't connect to either database.
This is wierd. Anybody have any ideas?