I am trying to get a SSRS report to run using a Sharepoint 2007 list as the source. I can get the report to build fine in BIDS but when I deploy it to the report server I get an error (see below). It seems to be an authentication issue but I've been pluggin a away for ever now with no luck. If anyone could tell me the best setup for the report server and the report package itself I would greatly appreciate it. I am using the follwing piece of code to pull the Sharepoint data: <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"> <Parameters> <Parameter Name="listName"> <DefaultValue>Operations Project Tracking</DefaultValue> </Parameter> </Parameters> </Method> <ElementPath IgnoreNamespaces="True">*</ElementPath> </Query> An error occurred during client rendering. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. Failed to execute web request for the specified URL. Unauthorized: The remote server returned an error: (401) Unauthorized. For more information about this error navigate to the report server on the local server machine, or enable remote errors.

Some more info: SQL 2008 and Reporting services on the same box MOSS 2007 on different box MOSS 2007 uses Windows Auth

Hi Sam, You are right. Based on the error message "Failed to execute web request for the specified URL. Unauthorized: The remote server returned an error: (401) Unauthorized.", we can know the issue occurred because of the credential passed to the SharePoint web service is invalid. By design, we can only use Windows Integrated authentication to access a web service from SQL Server Reporting Services(SSRS). So, please make sure the report server is in the same domain(or trusted domains) with the SharePoint server. Additionally, there should have a double-hop issue happen. When the user accesses the report, then the report server will try to use its own credential(not the client' credential) to access the web services. If the Reporting Services is running under on a local account, the reporting services will use anonymous account to access the SharePoint web service, this will cause the error happen. In this case, to fix the issue, please configure Kerberos for the report server. For more information about how to configure Kerberos authentication for the report server, please see: http://msdn.microsoft.com/en-us/library/cc281253.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT