BOE 4.1 SSO for Crystal Reports scheduling and publications

[Former Member]

Hi,

We have setup SSO for 4.1 to SAP BW which is using the sap tokens (assertion tickets) and everything is working fine.

However, we are getting database connection error when scheduling crystal reports and running publications which includes crystal reports. The error was "Details: Logon to underlying database failed".

Webi reports which use universe are have similar issue when viewing on demand. It does not single sign on. The reports only run when a username and password is entered.

Does anyone know how to get this to work?

[former_member926196]

Hi Philip,

You will require to configure SNC/STS for SSO to work.

http://service.sap.com/sap/support/notes/1650872

For STS:

http://wiki.sdn.sap.com/wiki/display/BOBJ/How+to+setup+SSO+against+SAP+BW+with+SAP+BO+BI4.0+Common+S...

For SNC

http://service.sap.com/sap/support/notes/1396213

Regards,
Ambarish

[Former Member]

Hi Ambarish,

Yes we have setup SSO and it's working fine.
The problem appears when this SSO mechanism does not work when we are scheduling crystal reports and publications.

So yes I know in 3.1 SNC was the solution for this. But on 4.1, setting up SNC causes the SSO using sap assertion tickets to break.

[former_member926196]

Hi Phillip,

Are you successfully able to refresh the report and the issue is only specific to scheduling? As far as I remember there had been a BUG which required configuration of SNC/STS for scheduling purpose.

-Ambarish-

[Former Member]

Hi Ambarish,

Okay. I might be a little obscure here.

When I mention that I've setup SSO using SAP assertion ticket, I actually mean I've setup SSO via the STS service using SAP Logon tickets and this SSO mechanism is working fine.

The issue is specific to scheduling of the report as well as publications of crystal reports with universes that does not use the SSO mechanism. And when I try so setup SNC, the SSO mechanism breaks altogether and nothing works. So I have to resolve to disabling SNC in order for reports SSO to work.

I'm running BO 4.1 SP5 which is the latest and greatest.

BR,

P

[former_member205064]

Checking these SAP notes should be helpful:-

1954305    Where to find the proper SNC DLL on the SMP 

1954202    HOW-TO: Configuring SNC using the COMMONCRYPTOLIB library found on the SMP 

1500150    Troubleshooting SNC server trust setup, STS issues, prerequisites, tracing, etc in SAP Business Objects XI 3.x and BI 4.x 

1913747 - When configuring SNC on RHEL linux 5.8 webi only works with 64 bit SNC friver and CR only works with 32 bit version