Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Cannot get QlikView/Qlik Sense to access SharePoint List Access is denied: the authentication has failed or has not been provided

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

Cannot get QlikView/Qlik Sense to access SharePoint List Access is denied: the authentication has failed or has not been provided

Last Update:

Nov 16, 2020 7:58:31 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jan 23, 2017 8:03:05 AM

A Data Connection to SharePoint list in QlikView/Qlik Sense fails. When trying to connect, the user receives an error:

Access is denied: the authentication has failed or has not been provided

 

Resolution:


The authentication error when connecting to SharePoint is caused by the service account ID not being passed to the zone. We will need to modify settings to allow for UserID and Password to be passed.

In order for QlikView/Qlik Sense to be able to connect to a SharePoint list using a URL, a local policy setting must be used. To add this local policy, perform the following steps on the QV publisher server(s) / QS Central Node (&Proxy RIMSs).

  1. From run enter gpedit.msc and press <enter>
  2. Under Computer Configuration expand administrative templates
  3. Expand Windows Components
  4. Expand Internet Explorer
  5. Expand Internet Control Panel
  6. Highlight Security Page
  7. Under Security Page you will see Site To Zone Assignment List
  8. In the window on the right hand in the upper left corner you will see Edit policy setting. Click on what looks like a link. That will open up a window for the policy setting.
  9. Make sure the Enable radio button is selected.
  10. Click on the show button.
  11. This will open up a show contents window
  12. In the value name box key in domain you want to allow (SharePointsite).
  13. In the value box key in a “1”. This will set the domain to local Intranet. This will allow any account on the server to connect to the domain via a URL.
  14. Click Ok, then Click Ok again.
  15. Close the Local Policy Editor

Related content:

How to load an Excel file from sharePoint to Qlik Using Qlik Web Connectors
Fetching data from files on SharePoint with Qlik Sense

Labels (1)
Contributors
Version history
Last update:
‎2020-11-16 07:58 AM
Updated by: