2

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.

3

So after messing with this off and on for a while I figured it out. It is possible. All this was done on one server with SharePoint 2013 enterprise and SQL Server 2012 Enterprise with SP2.

I have a default SQL server instance with all features selected, specifically the shared features "Reporting Services - Sharepoint" and "Reporting Services Add-in for Sharepoint Products". Then you have to run through the installer again and add a new instance. Then select "SQL Server PowerPivot for Sharepoint" (relational database check box at this point was not needed). After you do this you have to activate this feature in SharePoint. Here is a blog on how to do the PowerPivot setup.

Make sure this instance is at the same service pack level once you install it. After this I followed this walk-through, starting at step 2, to enable SSRS in SharePoint.

That is pretty much it. I now have a native SSRS site and SharePoint integrated SSRS site as well as PowerPivot/PowerView all on the same server. All databases are on the default instance. I only have SSAS installed for the PowerPivot instance and that is it.

| improve this answer | |
1

Your server has to be a member of the SharePoint farm before it will allow you to install SSRS in integrated mode. Refer to this article for more information.

| improve this answer | |
  • If it is all on the same server wouldn't it already be in the farm? – Brandon Frenchak Dec 3 '14 at 17:42
  • To add the database server, you don't have to install SharePoint onto it. To add SSRS, you have to have SharePoint installed on the machine just like an App Server. That is what I meant by it being in the farm, sorry for not being clear. – Your_comment_is_not_funny Dec 3 '14 at 17:49
  • I gotcha. I have sql and sharepoint installed on this same machine already. Do I still have to add itself to the farm somehow even if both are on one server? Sorry I am not that knowledgeable in sharepoint. – Brandon Frenchak Dec 3 '14 at 18:04
  • After I reread your question it sounds like the problem you have is that you are trying to add reporting services to the analysis services instance for powerpivot? If that statement is correct, then you are trying to add to the wrong instance. It has to be added to the database engine/instance that has your SharePoint databases. Also, you'd have to create new report databases for the integrated mode because they can't share the same ones as the native mode SSRS. I'd try to get at least one more machine to separate out the app, the cost should be trivial compared to what you paid in licenses. – Your_comment_is_not_funny Dec 3 '14 at 19:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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