The below mentioned script will take care of the steps listed below,

  1. Installs Reporting Services service and service proxy, and starts the service.2
  2. Creates a service proxy named “Reporting Services”.
  3. Creates a Reporting Services service application named “Reporting Services Application”.
  4. Enables the Power View feature for a site collection.

#Script for SSRS Configuration in SharePoint Integrated mode

  1. $starttime=Get-Date
  2. write-host -foregroundcolor DarkGray StartTime>> $starttime
  4. Write-Host -ForegroundColor Green "Import the SharePoint PowerShell snappin"
  5. Add-PSSnapin Microsoft.Sharepoint.Powershell –EA 0
  7. Write-Host -ForegroundColor Green "Install SSRS Service and Service Proxy, and start the service"
  8. Write-Host -ForegroundColor Green ">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"
  10. Write-Host -ForegroundColor Green "Install the Reporting Services Shared Service"
  11. Install-SPRSService
  13. Write-Host -ForegroundColor Green " Install the Reporting Services Service Proxy"
  14. Install-SPRSServiceProxy
  16. # Get the ID of the RS Service Instance and start the service
  17. Write-Host -ForegroundColor Green "Start the Reporting Services Service"
  18. $RS = Get-SPServiceInstance | Where {$_.TypeName -eq "SQL Server Reporting Services Service"}
  19. Start-SPServiceInstance -Identity $RS.Id.ToString()
  21. # Wait for the Reporting Services Service to start...
  22. $Status = Get-SPServiceInstance $RS.Id.ToString()
  23. While ($Status.Status -ne "Online")
  24. {
  25. Write-Host -ForegroundColor Green "SSRS Service Not Online...Current Status = " $Status.Status
  26. Start-Sleep -Seconds 2
  27. $Status = Get-SPServiceInstance $RS.Id.ToString()
  28. }
  30. $time=Get-Date
  31. write-host -foregroundcolor DarkGray StartTime>> $starttime
  32. write-host -foregroundcolor DarkGray $time
  34. Write-Host -ForegroundColor Green "Create a new application pool and Reporting Services service application"
  35. Write-Host -ForegroundColor Green ">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"
  36. Write-Host -ForegroundColor Green "Create a new application pool"
  37. #!!!! update "-Account" with an existing Managed Service Account
  38. New-SPServiceApplicationPool -Name "Reporting Services" -Account "<domain>\User name>"
  39. $appPool = Get-SPServiceApplicationPool "Reporting Services"
  41. Write-Host -ForegroundColor Green " Create the Reporting Services Service Application"
  42. #!!!! Update "-DatabaseServer", an instance of the SQL Server database engine
  43. $rsService = New-SPRSServiceApplication -Name "Reporting Services Application" -ApplicationPool $appPool -DatabaseName "Reporting_Services_Application" -DatabaseServer "<server name>"
  45. Write-Host -ForegroundColor Green "Create the Reporting Services Service Application Proxy"
  46. $rsServiceProxy = New-SPRSServiceApplicationProxy -Name "Reporting Services Application Proxy" -ServiceApplication $rsService
  48. Write-Host -ForegroundColor Green "Associate service application proxy to default web site and grant web applications rights to SSRS application pool"
  49. Write-Host -ForegroundColor Green ">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"
  50. # Associate the Reporting Services Service Applicatoin Proxy to the default web site...
  51. Get-SPServiceApplicationProxyGroup -default | Add-SPServiceApplicationProxyGroupMember -Member $rsServiceProxy
  53. $time=Get-Date
  54. write-host -foregroundcolor DarkGray StartTime>> $starttime
  55. write-host -foregroundcolor DarkGray $time
  57. Write-Host -ForegroundColor Green "Enable the PowerView and reportserver site features"
  58. Write-Host -ForegroundColor Green ">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"
  59. #!!!! Update "-url" of the site where you want the features enabled
  60. Enable-SPfeature -identity "powerview" -Url http://server/sites/bi
  61. Enable-SPfeature -identity "reportserver" -Url http://server/sites/bi
  63. ####To Verify, you can run the following:
  64. #Get-SPRSServiceApplication
  65. #Get-SPServiceApplicationPool | where {$_.name -like "reporting*"}
  66. #Get-SPRSServiceApplicationProxy