Kemp Support, how can we help?

The latest application delivery knowledge and expertise at your fingertips.

How to resolve issues editing Microsoft Office files from SharePoint when ESP is enabled

Scope

When utilizing Kemp's Edge Security Pack (ESP) feature with SharePoint (SP), you may run into an issue whereby you are unable to edit your Microsoft Office files. This is because the Office file has no Authentication Cookie associated with it. So in turn, the LoadMaster redirects the client to the LoadMaster’s ESP Auth-Proxy page to authenticate. 

You will either receive the following error:

Or you will see the Kemp login form within Microsoft Excel or Word: 

 

With SAML set as your Client-Side Authentication, your Office file might just hang and eventually show the below message. This is because ESP redirects you to ADFS due to a missing Authentication Cookie. 

 

Solution

  1. Enable Permanent Cookies on your SharePoint Virtual Service under ESP Options
  2. Configure Internet Explorer to Accept Third Party Cookies and add the SP site to your Trusted Sites

Note: This solution only works if clients are using Internet Explorer. This is because Chrome and Firefox and Edge are unable to associate authentication cookies with MS Office files. 

If you have no control over external clients and they use Chrome or Firefox, then you will need to install an Office Online Server. 

 

Configuration

  1. Enable Permanent Cookies on your SharePoint Virtual Service under ESP Options

For more information on Permanent Cookies, refer to the following article:  What Does The Use Session Or Permanent Cookies Option Mean?

 

Note: If you select Permanent Cookies only on Private Computers, you must ensure that your client always selects This is a private computer when logging in: 

 

 

Note: When SAML is configured, you must select Permanent Cookies Always:

 

 

2. Add the SP site to your trusted sites: 

IE > Internet Options > Security > Trusted Sties 

3. Configure Third Party Cookies:

IE > Internet Options > Privacy > Advanced

 

Related Knowledgebase Article:

What Does The Use Session Or Permanent Cookies Option Mean?

 


Was this article helpful?
0 out of 0 found this helpful

Comments

Avatar

Kenneth Meyer-Lassen

Now that Internet Explorer is soon officially end of life (June 15, 2022) and already unsupported on a lot of websites, customers are encouraged to move to Edge. How can we maintain this functionality using Edge (chromium) browser??

0

Avatar

Nick Smylie

Hi Kenneth Meyer-Lassen

This solution is only for internet explorer.  If you have no control over external clients and they use Chrome or Firefox, then you will need to install an Office Online Server. 

0