Hi, Now I am setting up Sharepoint Server 2010 reporting with SQL Server 2008R2 Reporting Service. The Sharepoint is in one server, and the sql server and report server are in another box. I think I finish all the steps of configuration and want to generage a fake report in Report Builder 3.0 to test. The datasource is sharepoint_config. At first, I chose "Windows Authentication" mode. The report could be generated successfully. But when I viewed the report in Sharepoint, it said "The request failed with HTTP status 401: Unauthorized. I checked some instructions for that and changed my mode to "Trusted account". This time, either when I ran or view the report, a different error said " An error has occurred during report processing. This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode." So what mode should I choose? or there are some other configuration steps I missed? Can someone help me, thank you!

There may be two possible issues: 1, user access to the report through SharePoint and 2, report/user access to the data source. Make sure that the domain or AD user has permission in SharePoint to access report library content and is a member of a database server role with access to the database. To isolate the issues, start by hard-coding credentials in the report data source that has appropriate access to the database. See if the user can run the report. If not, you can troubleshoot that problem alone. Once that problem is resolved, you can pass-through the user's credentials in the shared data source if this is a neccessary requirement (storing an application credential in the data source is often considered a best practice if it's permissable.) Paul Turley, MVP, www.SQLServerBIBlog.com *Please vote if helpful*

I am new in this field. Can you tell me more details about what I should do? I use the sharepoint admin account, so I think I have the access to sharepoint report library. This account is also the administrator account in database server. It has dbcreator, public, security, serveradmin and sysadmin roles in SQL server 2008 R2. Currently, RS is running on Sharepoint integerated mode. And in central admin, I set it in "Windows Authentication" mode. Everything goes well. I can run the report successfull, view the report on database server successfully. But when I view it in sharepoint, it still said "The request failed with HTTP status 401: Unauthorized." I have checked your instruction online. It told me to change mode to "Trusted account". But another error appeared as I showed above. I also edit the DisableLoopbackCheck registry key, but it didn't work. Can you tell me what I should do exactly? Thank you very much!

Hi Wendy567, There are so many reasons will cause the “The request failed with HTTP status 401: Unauthorized” error. For example, the Reporting Services Web service is not configured to use Windows integrated authentication. In order to deal with this issue, please refer to “5.4 The request failed with HTTP status 401: Unauthorized” section in the following link: http://msdn.microsoft.com/en-us/library/ee384252(v=sql.100).aspx Hope this helps. Thanks, Bin Long

Hi, Thank you for your reply. I have read this article before. But I have difficluty in locating the web site contains the reportserver virtual directory. Which one is the web site has reportserver virtual directory, SP10-TSQL2 (my database server name, also part of my report server url) or Sharepoint 80? And when I right click any site, I cannot see virtual directory. Do I need to create a virtual directory first? Could you show me more details in this? And in Section 5.4, it provides a solution of changing authentication mode to trusted account. It also refers that we will receive error: "This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode". That is my problem, too. How to specify credentials for the datasource that are windows credentials? Can you give me a step by step instruction? Thanks!