- Enable Kerberos on your Sharepoint Web Application (from central admin)
- Enable the Claims to Windows Token Service in Sharepoint (Make sure the service is running on all Web Front Ends)
- Create an HTTP SPN for the account that is running Portal application Pool
- Create a dummy SPN for the account that is running the service application
- Create an MSOLAPSvc.3 SPN for the service account running Analysis Services
- Configure Constrained Delegation for the Service Application account to Analysis Services
- Configure Constrained Delegation for the Application Server machine.
Showing posts with label Sharepoint Integrated Mode. Show all posts
Showing posts with label Sharepoint Integrated Mode. Show all posts
Monday, 3 December 2012
7 Easy Steps to Enable Kerberos for SSRS running in Sharepoint Integrated Mode - SQL 2012
7 Easy Steps!
Friday, 30 November 2012
SQL Server Reporting Services Service not installed after running Install-SPRSService and Install-SPRSServiceProxy
I was recently setting up a reporting server running in sharepoint integarted mode connected to an existing farm. After installing SQL 2012 in SharePoint integrated mode I executed following commands (Install-SPRSService, Install-SPRSServiceProxy) to setup the reporting shared service in sharepoint. The command executed successfully but i was unable to see SQL Server Reporting Services Service under system settings in Central Admin. I went through the sharepoint logs and couldn't find anything in there. NO ERRORS. After spending a lot of time i figured out the solution.
SOLUTION:
I downloaded Microsoft® SQL Server® 2012 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010 and installed on all WFE in the farm so they can be upgraded to use SQL 2012 Reporting Service.After successfully installing it and running the Install-SPRSService, Install-SPRSServiceProxy commands again the service appeared under system settings of the REPORT SERVER.
Subscribe to:
Posts (Atom)