Problem(Abstract): Datasource connections not listed in Data server by default

Symptom: We can see the datasource in the Admin console but not in the list of data servers.

Cause: This is default behavior.

Resolving the problem

Go to the Administrative Console -> Configuration -> Set properties -> Connections tab.

On the bottom, you will see "Data source capabilities"

Inside that, check the box which says "Allow web-based modeling"

Once you check this, the datasource would be present as data server.

References:

Access Manager provides a centralized environment to define, store, and maintain security information for IBM Cognos business information applications.

In one central location, you can set up and maintain secure user access to data, such as cubes and reports, that are created in other IBM Cognos applications. With Access Manager, you can also set up and maintain user signon information and auto-access privileges for the data sources and servers that contain the required data.

References:

Problem(Abstract)

When running report user is prompted to enter the signon but the check box "« Remember my user ID and password when connecting to this data source » is not displayed .

User has no signon saved in his profile

Cause

User capability

Diagnosing the problem

Check the user capabilities and persmissions

Resolving the problem

Cognos Administrator must grant user/group execute permissions for the Manage own data source signons capability

References: