Crystal Reports - ECC - SSO Issue

[Former Member]

Team,

System Details.

1. BOE XI 3.1 SP3

2. Crystal Reports 2008

3. SAP ECC 6.0

4. SAP NW 7.x

Scenario: Crystal reports running against ECC system. SSO configured on Crystal Report database configuration option, report is accessed through SAP NW portal (which in turn is configured to BO Info View using KM IVIEW option). Report fails with "The database login information is either incomplete or incorrect" error message.

BUT the same user id (as the user id ) when hard coded ("Use same database logon as when report is run") in Crystal Reports database configuration static option ("Use original database logon information from the report") works fine.

Please let me know your thoughts regarding how to debug this issue?

[Former Member]

Thanks very much for helping me.

[IngoH]

Hi,

if you want to have SSO for the report you need to :

- have the SAP Authentication configured and the SAP Roles imported

- the SAP Roles need to have the necessary rights on the BOE Server

and in your case because of the portal part :

- all machines need to be in the same domain

- all URLS need to be fully qualified

- trust between ECC and Portal needs to be configured

- your ECC system needs to accept portal token

ingo

[afzal_kar]

Hi;

You need to assign the proper credential of the crystal Report in the CMC. By which reports will be available on the infoview also.

If the problem still exists,please delete the existing username in the CMC Login dropdown. We have used this workaround several times and it worked.

Thanks

Afzal