SP 2013 and SQL SSRS 2012 integration

I've done this installation successfully a few times before.  On all other times for SP 2013 with SQL 2012 SSRS, I installed on the application server because it was the only server.

This time I'm installing into a FARM.  One of the DEV guys asked me to install it on one of the WFE server in the farm so i did.  The installation was successful.  to verify the installation I run this command.

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

and I get this reply..

WARNING: 'SQL Server Reporting Services Service' is already started on server 'Server1'

The next steps are to create a reporting services application. However, in central admin, that option doesn't show up under "Manage Service Applications" - "New"

The Microsoft instructions say this means it wasn't installed correctly. When I go to manage services, then select my WFE server, it doesn't show SQL Server Reporting Services Service

Yet when I go back and re-run the shell command it says it's installed and running. I've rebooted the farm to no avail. Anyone know what I did wrong?

Am I supposed to install this on the application server instead of the WFE?

Any help is greatly appreciated.


  • Edited by Statistic Tuesday, March 31, 2015 5:41 PM
March 31st, 2015 5:40pm

I think I have to install reporting services on the application server, and the reporting services add-in on the WFE.  Can anyone verify this?
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2015 5:52pm

Is "Server1" a WFE?

WFE, depending on memory and other usage patterns, can be faster to run SSRS on than the App Server. Did you run "Install-SPRSService" and "Install-SPRSServiceProxy" on Server1?

March 31st, 2015 6:00pm

Server1 was a WFE.  It was an additional server I built and added it to that farm.

I did run those commands, and as I said when I ran

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

and I get this reply..

WARNING: 'SQL Server Reporting Services Service' is already started on server 'Server1'

But when I went in to central admin, I didn't see that service running on that server.

I think I found documentation that I have to install reporting services on the application server, and the reporting services add-in on the WFE.  That's not the way it worked in 2010 though, so I'm confused.

Free Windows Admin Tool Kit Click here and download it now
March 31st, 2015 6:08pm

I went to a sample server where it's installed and working (albeit a stand alone server which is both application and WFE) and there is a service listed for SQL reporting services.  When that's there, one should be able to create the service application.

Microsoft says that if the service doesn't list, and/or if when you go to create the service application the option doesn't show up in the drop down, that it wasn't install correctly.  But All of the steps went off perfectly.  I was able to open SQL studio manager and see the system db's.  I also had all of the components installed according to add-remove programs.  I ran the two commands, then the get command and all worked, still no service listed for SQl reporting services.

I've uninstalled it all and i'm attempting to install it on the application server.

March 31st, 2015 6:13pm

Did you make sure SP1 for SQL 2012 was applied to that new SSRS instance?
Free Windows Admin Tool Kit Click here and download it now
April 2nd, 2015 12:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics