x

Difficulty in connecting to SharePoint Lists

Only slightly related to SQL server perhaps but I'm running out of options: I have a SSRS 2005 report that is accessing data from Sharepoint via a datasource. The data source is set with Integrated Security, it references a specified server and all is fine in dev, data is returned from the following XML query:

http://schemas.microsoft.com/sharepoint/soap/GetListItems {a95b0f38-f1d6-43cc-b8f1-26f76e46c4fe} *

However, once deployed to the report server I get the following error

• An error has occurred during report processing. o Cannot create a connection to data source 'SharepointList'.  Keyword not supported: 'http://servername/bs/it/oaa/sd/tasks/_vti_bin/lists.asmx;integrated security'.

i have not been able to find any information regarding this as yet and I hope someone can point me int he right direction. This report is deployed to a SSRS Report Manager, it does not use Sharepoint Integration.

more ▼

asked Aug 15, 2010 at 09:34 PM in Default

avatar image

Fizz
67 8 8 10

(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

It looks to me as if there is a problem with the connection string / data source definition. For help with these, I usually hit http://WWW.connectionstrings.com.

A further thought - can you run the report successfully in the development tool? If so, then you might be able to just redeploy the data source element of the ssrs project.

more ▼

answered Aug 15, 2010 at 10:29 PM

avatar image

ThomasRushton ♦♦
41.5k 20 50 53

(comments are locked)
10|1200 characters needed characters left

I can run it in the development tool and data is returned. The data source in dev is identical to the datasource on the report server.

I was assuming there might be something I need to set on the server but I haven't found anything yet.

more ▼

answered Aug 15, 2010 at 11:06 PM

avatar image

Fizz
67 8 8 10

(comments are locked)
10|1200 characters needed characters left

Thank you all

I have fiddled with it a bit more and can now connect to Sharepoint. The report has gone back to the developer to resolve the issues in the query and/or report format etc.

Again

Thanks

more ▼

answered Aug 16, 2010 at 01:31 AM

avatar image

Fizz
67 8 8 10

so what was the problem? EMNTK[1]

[1] Enquiring Minds Need To Know.

Aug 16, 2010 at 11:20 AM ThomasRushton ♦♦
(comments are locked)
10|1200 characters needed characters left

Hi Thomas

I hate to admit it but there was a typo in the TYPE - XM:L rather than XML.

Fixing that got through the connection but then hit "Failed to execute web request for the specified URL."

I believe it is related to permissions but haven't gone into it too far as yet. Lots of "You are not authorized to view this page" type of comments in the error message.

more ▼

answered Aug 16, 2010 at 03:26 PM

avatar image

Fizz
67 8 8 10

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x681

asked: Aug 15, 2010 at 09:34 PM

Seen: 1819 times

Last Updated: Aug 15, 2010 at 09:34 PM

Copyright 2016 Redgate Software. Privacy Policy