SAP Knowledge Base Article - Public

3665189 - Excel Add-in Is Triggering Issues While User Attempts To Login Using SSO

Symptom

Errors faced: 

  • "Could not establish a connection." 
  • "Unexpected error in server communication; session needs to be closed."
  • "The remote server returned an error: (400) Bad request."

Environment

  • SAP Cloud for Customer
  • BYD Business by Design 

Reproducing the Issue

  1. Click to Login.
  2. Screen will pop up to sign in using SSO.
  3. Input SSO details.
  4. Then the error messages will appear.

Resolution

Check the below points in order to solve this scenario.

  1. Ask affected user to use this URL format: https://my000000-sso.businessbydesign.cloud.sap for SSO to login to Excel Add-in.
  2. There are admin restrictions to business users, SAP offers an MSI file installer, please install it. 
  3. Kindly download the latest version of the Add-in from the downloads section and test again.
  4. Also test without being logged to VPN to check how system responds then.
  5. Check if the user has the correct URL for the resource being accessed. Additional permissions may be required from the resource owner to proceed.

If none of these alternatives was successful to solve the problem, please reach out to SAP support for further guidance, while doing it confirm if the issue also reproducible using Basic authentication and provide this information as well. 

Keywords

Excel; Add-in; Triggering; Issues; SSO; Login; Could; not; establish; connection; Unexpected; error; server; communication; session; closed; remote; server; returned; error; 400; Bad request. , KBA , SRD-CC-OIN-XL , Excel Integration , Problem

Product

SAP Business ByDesign 2508 ; SAP Cloud for Customer add-ins all versions