HowTo: Change the default signon used for a datasource

How to avoid data source security login prompt when running a report. When the users attempt to run a report, they are prompted to enter the login ID and password for the database.

Resolving the problem

Either there was no signon defined for the datasource being used for the report, or the credentials were invalid. We need to go the Signon datasource object, and enter in valid database credentials.

Steps: To change the signon user and password:

     

     1.   In Cognos Connection, click the Tools button, and select Directory.

     2.   Once the directory screen loads, click the Datasources tab.

     3.   Find and click on the name of the datasource.

     4.  The next screen will also show the name of the datasource. Click on it.

     5.   Click on the Set Properties icon.

     6.   Once the properties screen loads, click the Signon tab.

     7.   Near the top of the page there is an Edit the signon link. Click on it.

     8.   On this screen, enter in an appropriate user name and password.

Note that there are two levels involved that usually have the same name (the name of the datasource), so ensure that your breadcrumbs look similar to:

Directory > Cognos > [datasourcename] > [datasourcename]

If you don't see a signon tab in the properties screen, but you do see a Connections tab, then you haven't drilled down deep enough.