Reports not picking the sign-on in the data source connection

[swapan1189]

Hi Everyone,

I am running a Cognos report. There is a datasource connection with sign-on for the package used for the report. However while running the report, it is asking for a datasource user Id and password. I test connected the data source connection and it is working fine. This issue is coming after we had reports migrated from one env to another. Before it was working fine. Report is working fine in lower environment as well. Had re-migrated the report as well but still issue persists. Any leads would be helpful over here.

Regards,
Swapan

[MFGF]

Hi Everyone,

I am running a Cognos report. There is a datasource connection with sign-on for the package used for the report. However while running the report, it is asking for a datasource user Id and password. I test connected the data source connection and it is working fine. This issue is coming after we had reports migrated from one env to another. Before it was working fine. Report is working fine in lower environment as well. Had re-migrated the report as well but still issue persists. Any leads would be helpful over here.

Regards,
Swapan

Are you by any chance using the RTM build of 10.2.1? I recall this was a bug in the original release - packages with multiple data sources were problematic.

Cheers!

MF.

[swapan1189]

Its RTM-10.1.29.0

[MFGF]

Its RTM-10.1.29.0

Not that, then.

Check that the signon defined within the data source definition has permissions for the "Everyone" group to use it.

Cheers!

MF.