Skip to main content
I am getting the following error when I try to view any of the new standard reports from SP1: "The request failed with HTTP status 401: Unauthorized."  Everything else on the system appears to be working fine.  Any ideas?
First try going through the SQL Reporting Services web site and see if the reports are there.  If not, you might want to go back over that section of the "Getting Started" guide.  If they are there and you're using a distributed install, try checking your Kerberos settings.
The reports are on the Reporting Services site.  I was under the impression that I am running a Standalone install since MOSS/K2/IIS are on one machine and SQL is on another.

Hi,


A single server environment includes SQL Server Reporting Services (SSRS) on the same server as the rest of the K2 components.


The reason you require Kerberos is because K2 Server impersonates the user when running the report and then connects to the reporting services web service. Since SSRS is on a separate server this requires Kerberos authentication.


The simplest way to get around this (without Kerberos) would be to install Reporting Services on the same server as the rest of the components. Alternatively Kerberos is the only other option.


Hope this helps.


Ok thanks for the explaination.  Is there a detailed writeup on what needs to be configured for Kerberos?


I write a blog entry on this before.  You can see if this is useful.


http://k2underground.com/blogs/johnny/archive/2007/12/07/k2-blackpearl-hf2-01-distributed-installations.aspx


 


There will also be a new KB article coming out very soon(this week) as well as a kerberos tool being posted on the blackmarket area.

And here is the new paper


 


http://k2underground.com/files/folders/technical_product_documents/entry21001.aspx


 


 


Reply