COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: swapan1189 on 21 Sep 2015 11:05:32 AM

Title: Reports not picking the sign-on in the data source connection
Post by: swapan1189 on 21 Sep 2015 11:05:32 AM
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
Title: Re: Reports not picking the sign-on in the data source connection
Post by: MFGF on 21 Sep 2015 12:22:28 PM
Quote from: swapan1189 on 21 Sep 2015 11:05:32 AM
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.
Title: Re: Reports not picking the sign-on in the data source connection
Post by: swapan1189 on 21 Sep 2015 01:51:55 PM
Its RTM-10.1.29.0
Title: Re: Reports not picking the sign-on in the data source connection
Post by: MFGF on 22 Sep 2015 04:34:19 AM
Quote from: swapan1189 on 21 Sep 2015 01:51:55 PM
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.