Hi,
I'm facing an DB2 and Cognos issue.
Follows the scenario:
I had an database cataloged on server using DB2 SERVER authentication and the data source with a connection to this db already existed and worked fine.
We had to change the database authentication to SERVER_ENCRYPT.
On the server, I can connect to the database by command line successfully. When I test the connection on the data source (on Cognos Administration) it fails showing me the following error:
(http://i50.tinypic.com/mj3576.jpg)
It was supposed to work, right? But it doesn't.
When I cycle an environment component such as a report dispatcher, it works (when i test the connection on the data source). I believe this happened because content store stores different kind of data including connection and authentication data.
Since we need to make authentication changes on a production server, we just don't want and can't face this issue.
Does anybody know the cause or how to prevent this from happening in the future, please?