Troubleshooting
Problem
When setting up Cognos and trying to connect to a MS SQL windows authentication database, the test fails with [ ERROR ] IPFTEST-006 Content Manager failed to connect to Database.
Environment
Content store is MS SQL Server (Windows Authentication)
Resolving The Problem
When changing the configuration to use SQL Server (Windows Authentication), Cognos Configuration was unable to connect to the database and therefore failed to start.
The service may still be using the default “Log On As” credentials in services.msc
Changing the services.msc “Log On As” credentials to the Active Directory account, Cognos Configuration was able to connect and start Cognos successfully.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"Content Store (MSSQL Server Windows Authentication)","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.0.x;11.1.x","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
27 March 2019
UID
ibm10878500