I'm having problems configuring SSRS in integrated mode, whenever I try to do anything with SSRS (including create a data source in a report library) I get a 401 Error. I'll try to describe my setup the best I can.
My farm consists of 3 servers.
SPSQL1 - Contains all the databases needed for SharePoint
SPAPP1 - Central Admin and SSRS (DNS Alias REPORT1)
SPWFE1 - Web Front End
Outside of the environment I have
CUBE1 - SSAS
SQL1 - RDB
I have the following SPN's setup:
On spapp_user (Which also is the service account for SSRS)
On cube_user I have
On sql_usre I have
On spwfe1, spapp1, and spapp_user I have setup constrained delegations to
I also have setup the reporting services config file to negotiate instead of use NTLM. And the Applicaon is using classic authentication since we're trying to use Windows Authentication in the reports we want to create when we can actually create them.
So far I have had no luck, however I am able to succe
View Complete Post