Wanted to know if I can have two SSRS instances on the same server, one in native mode and one in SharePoint integrated mode.
I have one SSRS instance in native mode on a SQL server default instance (mssqlserver). I added the second SSRS PowerPivot instance to get PowerPivot/PowerView in SharePoint, but realized I have to have an SSRS instance in integrated mode as well to get this feature to work. When trying to add this SSRS instance in integrated mode to the PowerPivot SQL instance, it only gives me the option for native mode and integrated mode is grayed out.
I am running SQL 2012 SP2 enterprise on the same server as SharePoint 2013 enterprise. I wanted to have both because our ERP utilizes the SSRS native mode in their reports and you can set security through the ERP and have the users view the reports within the ERP system. If this cannot be done, we will have to take all the reports and dashboards out of the ERP and manage them separately with the windows security in SharePoint.