Pro SQL Server 2012 Reporting Services

CHAPTER 12  DELIVERING BUSINESS INTELLIGENCE WITH SSRS

run this as an administrator to perform the following steps. If not, you will receive the error displayed in

Figure 12-17.

Figure 12-17. Error if SharePoint management shell not in administrator mode

Type in the following PowerShell command to install the SharePoint Reporting Service. Hit the

Enter key after typing in the command to execute it.

Install-SPRSService

Type in the following PowerShell command to install the PowerShell service proxy. Hit the Enter key

to execute the command.

Install-SPRSServiceProxy

Type in the following PowerShell command to start the service. After typing the command on one

line, hit the Enter key to execute the command.

Get-spserviceinstance –all | where {$_.TypeName –like “SQL Server Reporting*”} | Start-SPServiceInstance

Figure 12-18 shows the result after completing the steps installing and starting the Reporting

Services SharePoint Service. For the fifth step, you need to create a new Reporting Services Service

Application.