Geek asks and answers

SharePoint List Data Source Providing HTTP 401 "Unauthorized" Error

I created a report that uses a SharePoint list as a data source. The data source is configured to use Windows authentication (built-in security) in SSRS. It works fine in SSRS / BIDS, but when deployed in a Report Manager environment, I get an error:

An error occurred while processing the report. (rsProcessingAborted)

Query execution error for the 'ListData' dataset. (rsErrorExecutingCommand)

An error occurred while accessing the specified SharePoint list. The connection string may be invalid. Check if the connection string is correct. (RsSPDataProviderError)

Request failed with HTTP status 401: Unauthorized.

I deployed both the report object and the data source to the environment from BIDS. I checked the properties to confirm that integrated security was also installed at the end of the report manager, so I'm not sure why it is not transferring credentials properly to the source.

Any ideas / suggestions?

+5
source share
3 answers

An SSRS service account will not help you. It is good to have a specific service account to start the SSRS service, but this is not what is used for authentication. It is also useful to set up a runtime account on the server using the Reporting Services Configuration Tool, which helps you run reports without user intervention, but again, that is not your problem.

Kerberos - , , , .

Sharepoint , Windows .

Reportuser (, reportuser @[domain].com). , , SharePoint.

BIDS/visual studio " Windows ( )". - . ( ).

- .

, "Connect using":

" , "

, ( ): reportuser@domain.com

: " Windows "

- .

+8

:

  • "" . . Image

  • , web.config. , w3wp.

+2

, , , , - SharePoint Designer Visual Studio . , , , . . , SharePoint Designer. SharePoint Designer , , , SSRS Visual Studio. Windows .

0

More articles:


All Articles