I have 2 SQL Servers (SQL01 has all Content DBs and SQL02 has all Service App DBs) and 2 SharePoint 2013 Servers with Enterprise edition. Just couple days ago, I installed Power Pivot in SP mode and Analysis Services on SQL Server(SQL02). I successfully configured the Power Pivot, but I don't see SSRS Services Application listed under Manage Service Application to create one.When I try to run "Install-SPRSService" on SP Servers, I get 'The term Install-SPRSService is not recognized error. What am I missing here? Please help.

1 Answer 1


Couples of things to make sure:

  1. install SQL Server Reporting Services in SharePoint mode
  2. the SQL Server Reporting Services Add-in for SharePoint 2013. I think this part is missing that's why your command is not recognized.

Check more here https://msdn.microsoft.com/en-us/library/ms144289.aspx#bkmk_no_ssrs_service

  • I have installed both. Also I have Reporting Services- Native and Analysis Services on all same instance. Is that right? And do I need to install these on both the SQL Server. Right now, I have it on only one server(SQL02).
    – Kalai
    Sep 19, 2016 at 13:35
  • I uninstalled Reporting Services native mode and reinstalled "Reporting Services - SharePoint" and "Reporting Services Add-in for SharePoint Products" on both SQL servers. But I am still getting the same error. The term 'Install-SPRSService' is not recognized as the name of a cmdlet,.... I am working on this issue for sometime now, but couldn't find a solution. Any help?? Thanks
    – Kalai
    Sep 19, 2016 at 18:14
  • Is sharepoint server are different than sql server or everything on one box?
    – Waqas Sarwar MVP
    Sep 19, 2016 at 18:38
  • Did u install anything related to ssrs on sharepoint server?
    – Waqas Sarwar MVP
    Sep 19, 2016 at 21:01
  • I made a mistake in my previous comment and I deleted it. I installed "Reporting Services - SharePoint" and "Reporting Services Add-in for SharePoint Products" on SharePoint servers and installed everything on SQL Servers. And now I could create SQL Servers Reporting Services on SharePoint.
    – Kalai
    Sep 20, 2016 at 17:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.