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 (...)"
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
SAP Knowledge Base Article - Public