Sharepoint list in reporting services has invalid connection string when deployed.


  • I'm using SSRS 2008 R2 to create a report based upon a number of sharepoint lists. All but one of the lists work correctly. If i use a sharepoint site such as


    the report works fine, whereas if i use


    as the connection string i can see all of the lists and preview my report in BIDS (all working fine) but when i deploy to report manager i get the error:

    • An error has occurred during report processing. (rsProcessingAborted)
      • Cannot create a connection to data source 'RidgianBI_SharepointLists'. (rsErrorOpeningConnection)
        • The connection string is not valid. (rsSPDataProviderError)

    My assunmption is that it doesnt like the data source as it doesnt have a site prefix at the end, but if that is the case why does it work in BIDS?



    Friday, August 12, 2011 1:46 PM


  • Hi jay,

    Thanks for posting your question here. Based on my research, it seems like this issue caused by the Catching Shared Datasets.

    I guess that when you create the dataset in BIDS, the datasource is http://intranet.mycompany.local/it, it helps you locate to the exact position of the list. Actually, after first run, the results and the correct server URL has been cached. So although you used http://intranet.mycompany.local in the datasource, the report still displays the correct result when you preview it.

    However, after you deploy the report to reportserver, when the report first run, it will get the data based upon the datasource and dataset again. If the connect string is http://intranet.mycompany.local, it can’t locate to the list in the subsite: http://intranet.mycompany.local/it.

    Hope it helps you. For more information, please refer to: Caching Shared Datasets (SSRS).


    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    • Marked as answer by jayjayt1988 Tuesday, August 16, 2011 12:31 PM
    Tuesday, August 16, 2011 11:18 AM