Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Qlikview Server cannot connect to Sharepoint via owssvr.dll

Dear Qlikview users,

I am developing an application using Qlikview that needs to get the data from a sharepoint list. After succesfully creating the linkages and building the application on my work laptop, i have decided to move it to a Qlikview server (running 11.2) so it can be accessed by the requested people.

The connection is made using owssvr.dll and then using the List ID and the View ID. (i can provide more information if needed)

The problem that i am experiencing is the following:

The application is not able to connect to the sharepoint list from the Qlikview server. The Server is running Win Server 2008 R2 and Qlikview 11.2. When i try to run it through Qlikview Management Console, i get the "Access denied" error.

28/05/2013 13:44:42:       Error: Access is denied.

28/05/2013 13:44:42:       General Script Error
28/05/2013 13:44:42:       Execution Failed
28/05/2013 13:44:42:      Execution finished.

I have read on forums and here on the QlikCommunity, and i have granted full access for the server users to the share-point list.

Did any of you stumble upon the same issue before? Any ideas / feedback are highly appreciated.

Thanks & Kind regards,

Silvercode

2 Replies
Not applicable

Re: Qlikview Server cannot connect to Sharepoint via owssvr.dll

I had the same situation on that.

I think you have to below Internet option dialog settings (IE).

  1. log on to host server by the account who is running QlikView server
  2. open IE -> Internet option -> security tab -> Sites
  3. add your sharepoint server url (http://SHAREPOINTSERVER)

Now the system account will be able to access to the sharepoint. Good luck!

canoebi99
Not applicable

Re: Qlikview Server cannot connect to Sharepoint via owssvr.dll

Hi Silvercode,

Did you ever get a solution to this? I have the same issue ... out of interest where you using Qlikview web server for QV or IIS? I am using Qlikview web server on one server for QV and trying to access sharepoint on another server but that is using IIS .... I am wondering if I should reconfigure Qlikview on IIS.

Cheers

Ben