Error Viewing Standard Reports

Forum|Forum|18 years ago
January 4, 2008
7 replies
15 views

+6

jthrasher

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?

D

+11

DavidL1
Forum|Forum|18 years ago
January 4, 2008

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.

Like

J

+6

jthrasher
Author
Forum|Forum|18 years ago
January 4, 2008

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.

Like

J

+10

JohanL
Nintex Partner
Forum|Forum|18 years ago
January 7, 2008

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.