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.
Couples of things to make sure:
- install SQL Server Reporting Services in SharePoint mode
- the SQL Server Reporting Services Add-in for SharePoint 2013. I think this part is missing that's why your command is not recognized.