Monday, December 15, 2014

Install SQL Server Reporting Services in multi server SharePoint 2013 farm with Windows 2012 R2 and SQL Server 2014 hosted in Azure VMs

Recently I installed SQL Server Reporting Services in SharePoint integrated mode in following multi server environment. I used Windows Server 2012 R2 for the operating system and SQL Server 2014 as the database server. My server farm is hosted in Azure VMs.
image
So following are the steps I used to install and configure SSRS

1. Installation of Reporting Services in SharePoint mode and Reporting Services add-in for SharePoint in Application server
  • Download SQL Server 2014 image in application server and start the setup
  • Select Reporting Services – SharePoint and Reporting Services Add-in for SharePoint
  • Complete the installation
rs

2. Installation of Reporting Reporting Services add-in for SharePoint in WFE server
  • Download or copy SQL Server 2014 image in WFE server and start the setup
  • Select Reporting Services Add-in for SharePoint
 image
  • Complete the installation
3. Register SQL Server Reporting Services service in SharePoint 2013
  • We have to execute following two commands in both servers
Install-SPRSService
Install-SPRSServiceProxy
4. Start SQL Server Reporting Services service in App server
image

5. Create new SQL Server Reporting Services service application in Central Administration
image
That’s all we need to do.

Caution !!

Prior to the above successful configuration, I tried the same using Reporting Services Add-in utility downloaded from Microsoft.

Unfortunately it got the SQL Server Reporting Services Service stuck in Starting
Capture
Finally I was able to complete it after downloading the SQL Server image to my server to do the configuration as I mentioned above

3 comments:

Dileepa said...

thanks very helpful!

Unknown said...

thank you for your help !

Unknown said...

SQL Server Reporting Services Service is stuck at the Starting state, any more details description on how to resolve this issue?