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!


  • 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. 

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 AdminI 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.