Reports to be run using db credentials

[Niranjan_9]

Hi,

I have a reporting project setup in Cognos that uses a functional ID. But I have a requirement in which user wants to run reports using their DB credentials.
     But the only way I've been able to do it so far was to purposely use an invalid username in the signon. That caused Cognos' initial connection attempt to fail (as desired), which in turn caused Cognos to prompt the user for their db logon (as desired). But unfortunately, Cognos doesn't seem to remember that logon for the rest of my session. I'd expected to prompt once per session (no matter how many reports I run without logging off), but it seems to be prompting me once per report (which is more annoying, of course).
Is there any other better way , Can anyone spare any other thoughts on this , Thanks !

[AnalyticsWithJay]

Hi,

Cognos checks for DB credentials in the following order:

1. Is there a connection signon that they have permission to?
2. No? Then are there stored DB credentials in their user profile?
3. No? Then prompt the user to enter credentials

The reason you're getting prompted is because you don't have #2 setup. Go to your Profile -> My Preferences and go to database credentials.

Cheers!
Jay

[Niranjan_9]

Thanks Jay,
It is what is happening, but for some different reasons I want to prompt the user credentials (of the db) once per session.
I remember seeing the remember by ID and password sometime in the past.
But everytime I run a report it prompts the signon credentials.

We have a process id that is valid and if I save the signon it works for me, but for Auditing purpose for a couple of days , I want to run the reports using the db credentials, but some users are complaining that they cant enter for every report run, they are ok to prompt it once per session after logging into Cognos.

Any help is highly appreciated , Thanks !

[Niranjan_9]

HI,

Even , If I am able to query the db using the cognos logon information my problem will be solved.
I tried using the external namespace, but it says logon failed , thought the user id has access in the DB.
I can save the XId and pwd in the signon but it needs to be changed everytime it expires.

[Niranjan_9]

Any help or thoughts guys.

[AnalyticsWithJay]

Any help or thoughts guys.

You'll need to use an external namespace for your user credentials to be saved.

If the logon failed, have your user use a database client (Management Studio, PL/SQL Developer, whatever), and logon using their credentials. If authentication is successful, the issue is with your configuration in Cognos, otherwise the issue is with database permissions.

You could try DOMAIN\username if username alone doesn't work.