title: SharePoint List data source giving HTTP 401 "Unauthorized" error
body: <p>I have built a report that uses a SharePoint list as its data source. The data source is set to use Windows Authentication (integrated security) in SSRS. It runs just fine in SSRS/BIDS, but when deployed to the Report Manager environment, I receive an error:</p>
  <blockquote>
  <p>An error has occurred during report processing. (rsProcessingAborted)</p>
  <p>Query execution failed for dataset 'ListData'. (rsErrorExecutingCommand)</p>
  <p>An error occurred when accessing the specified SharePoint list. The connection string might not be valid. Verify that the connection string is correct. (rsSPDataProviderError)</p>
  <p>The request failed with HTTP status 401: Unauthorized.</p>
  </blockquote>
  <p>I have deployed both the report object and the data source to the environment from BIDS. I checked the Properties to confirm that integrated security was set on the Report Manager end as well, so I am not sure as to why it's not passing the credentials properly to the source.</p>
  <p>Any ideas/suggestions?</p>