Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Sharepoint list not found after deploying SSRS Report to server

  Asked By: Gabriela    Date: Oct 15    Category: Sharepoint    Views: 2066

I have a SQL Report Writer report that uses the enesys software component to display a sharepoint list.

While in Visual Studio, I can preview the report and the sharepoint list is found and populates the report just fine.

Once I deploy the SSRS Report to the server I get a message stating the sharepoint list cannot be found.

Wondering if anyone has seen behaviour like this before. The list is there. I don't see why it works while in the dev environment and doesn't on the server.

Any help or suggestions would be appreciated.

An error has occurred during report processing.
Query execution failed for data set 'IMRProjectSlate'.
The list IMRProjectDocket could not be found in the site http://servername/sites/AppDev/Bus_Tech/



1 Answer Found

Answer #1    Answered By: Bernice Puckett     Answered On: Oct 15

Turns out the reason for this failing (which was not easily gathered from the error  message) is that I was using Windows authentication and in order to get it to function properly, I needed to use an authorized service account.