Product:
Cognos BI and Planning version 8.x

Symptom:
The Cognos service for planning or BI does not start, when you click on start in Cognos configuration

Error Message:
[Logging]
1. [ ERROR ] IPFTEST-006 Logging failed to connect to Database:jdbc:JSQLConnect://Server_Name:1433/Database_Name

Cause:
The SQL login created for the Cognos Audit or Planning Store are set to change password at first login.

Solution:
In SQL server management studio, right click and select properties for the SQL login used.
Uncheck “User must change password at next login”
Click OK

Now start the Cognos services from Cognos configuration.

www.cogknowhow.com