SAP Knowledge Base Article - Public

2541508 - Error when trying to access BW system using SSO

Symptom

When trying to access a BW system using SSO in Analysis for Office, the errors below occur:

"Single Sign On failed. (...)"

"LOCATION CPIC (TCP/IP) on local host XXX with Unicode (...)"

Error SSO.png

The traces contain entries similar to the following:

------------------
General .NET Exception:
LOCATION CPIC (TCP/IP) on local host (...) with Unicode
ERROR SncPDLInit()==SNCERR_INIT
Unable to load GSS-API DLL
named "(...)"
TIME Mon (...)
RELEASE (...)
COMPONENT SNC (Secure Network Communication)
VERSION 6
RC -1
MODULE sncxxdl.c
LINE 462
DETAIL LoadLibrary("...")
Error 193 = "... is not a valid Win32
application."
SYSTEM CALL LoadLibrary
COUNTER 4
------------------

Environment

SAP Analysis for Microsoft Office

Cause

The system is unable to find the correct SCN dll. The issue could be the location of the folder or it might be wrong DLL for the specific version 32/64.

Resolution

This error means that the client machine where AO is running has not found any SNC library to use to encrypt the RFC connection. To fix the insecure connection, create an environmental variable SNC_LIB_64 in your client machine and point it to the folder where the SNC libraries are located.  

Refer to SAP note 2025528 and specify an environment variable specific for the bit size of Analysis for Office.
Refer to SAP note 2115486 to download the DLL for the specific bit size of Analysis for Office.

For example:
If using AO 32 bit, define the environment variable SNC_LIB_32 with a valid 32 bit DLL.
If using AO 64 bit, define the environment variable SNC_LIB_64 with a valid 64 bit DLL.

Keywords

SSO, single sign on, logon, login, error, exception, client , KBA , BI-RA-AO-CON , Please use component BI-RA-AO-XLA , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions