Cognos BI and Planning version 8.x
The Cognos service for planning or BI does not start, when you click on start in Cognos configuration
1. [ ERROR ] IPFTEST-006 Logging failed to connect to Database:jdbc:JSQLConnect://Server_Name:1433/Database_Name
The SQL login created for the Cognos Audit or Planning Store are set to change password at first login.
In SQL server management studio, right click and select properties for the SQL login used.
Uncheck “User must change password at next login”
Now start the Cognos services from Cognos configuration.