MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Kerberos not working with SSRS on sites below the top level

  Asked By: Casey    Date: Apr 21    Category: MOSS    Views: 1175

I've fought through getting Kerberos authentication to pass credentials from Reporting Services to SSAS on another server. However, this does not work for Report Libraries in sites below the top level. E.g., reports work in http://myserver/reportlibrary, but they do not work in http://myserver/reportsite/reportlibrary. Instead, I get this error when trying to access a report:

"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with HTTP status 401: Unauthorized."

Is this just another bug/limitation with MOSS?

The Setup:

MOSS/SSRS (Integration Mode) running on a server farm on a single server: myserver.mydomain.org
Service Account for all Services: mydomain\myaccount (trusted for delegation, member of IIS_WPG)
myserver trusted for delegation
SSAS running under Local System on ssas.mydomain.org.
SETSPN -L mydomain\myaccount results:
MOSS Authentication Settings
Authentication Type = Windows
Default Authentication Provider = Negotiate (Kerberos)
Anonymous access not enabled
IIS Settings
SSRS on Default Web Site: Port 8080
Application Pool Identity mydomain\myaccount
Security: Windows Authentication
MOSS on Sharepoint-80 Site: Port 80
Application Pool Identity mydomain\myaccount
Security: Basic Authentication except _vti_bin/ReportServer is Windows Authentication



1 Answer Found

Answer #1    Answered By: Girja Garg     Answered On: Apr 21

As far as I can tell, this is a design flaw with MOSS/SSRS in integration mode  not allowing kerberos  configuration below the root level: