We'll install the SSRS 2012 SP1 SharePoint mode in PROSP13SRV02 which is going to host most of BI service applications. This server is not meant to serve user requests hence we'll not install SSRS add-in in this machine. We'll install SSRS add-in in PROSP13SRV01 later on. Follow the screenshots below to install SSRS 2012 SP1 in SharePoint mode. I am using SSRS 2012 SP1 media.

A. SQL Server 2012 Business Intelligence Topologies and licensing

REF:

http://msdn.microsoft.com/en-us/library/dn305848(v=sql.110).aspx

http://msdn.microsoft.com/en-us/library/hh231674.aspx#bkmk_example_deployments_2013

 

B. Install SSRS 2012 SP1 in SharePoint mode


Make sure the account you are logged in with to install Reporting Services in SharePoint mode has administrative rights in local computer, and also that it is a member of Farm administrators group. If the logged in account satisfies these criteria, then the installer with register the Reporting Services service. If Reporting Services SharePoint mode was installed before SharePoint was installed or if setup account does not have above permissions, the installer will not be able to register the service which then will have to be done manually. The manual step has also been outlined below.

C. Register and start SSRS Service.

This step might not be necessary if you installed SSRS in existing SharePoint farm, in which case the SQL Setup will configure and start the service. You can verify if the service is up and running or not. Just go to Manage services on Server.

If the service is not there then follow the steps outlined below to register and start the service. This is usually necessary in following cases:

  • Reporting Services SharePoint mode was installed before SharePoint was installed
  • The account used to install Reporting Services was not member of Farm Administrators group 
  • Start SharePoint 2013 Management Shell, and run the following command

Install-SPRSService

  • Run the following command to install the service proxy.

Install-SPRSServiceProxy

  • Run the following command to start the service

get-spserviceinstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance

  • You can also start the service from Central Administration.
  • If the Reporting Services service stays in the Starting status and does not change to Started, verify the 'SharePoint 2013 Administration' service is started in Windows Server Manager.

D. Create Reporting Services Service Application

 

 

E. Install the SSRS Add-in in Web Server PROSP13SRV01

F. Provision Subscriptions and Alerts

Follow one of the methods specified in this link. http://msdn.microsoft.com/en-us/library/hh231725(v=sql.110).aspx

G. Configure Email Setting


Click on SSRS Service Application and put your SMTP Server details on the Email.

Leave a Reply

Your email address will not be published. Required fields are marked *