3

I understand that on the computer running SSRS in SharePoint Integrated mode I must also have a minimal installation of SharePoint. The following from MSDN illustrates this:

Components for a two-computer deployment

My setup consists of a SharePoint web front end and a SQL server so the only way for SSRS Integrated Mode to work is if do one of the following:

  1. Install SSRS using SharePoing Integrated mode on the SharePoint front end server.
  2. Or I put a minimal SharePoint 2010 installation on the SQL Server.

Since installing SharePoint on a SQL Server is a no-no, I must do the former. Now my question to you experts is why. Why do I need to have SharePoint installed on the same computer as SSRS Integrated Mode when I do not need this in native mode.

Based on an error I get, pasted below, I can assume that it is because it needs access to the object model. Again I ask why. Why does it need the object model in this case but not when running in native mode. Does it not also have access to the object model when in native mode?

The configuration parameter SharePointIntegrated is set to True but 
SharePoint Object Model cannot be loaded. The error was: 
System.IO.FileNotFoundException: Could not load file or assembly 
'Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, 
PublicKeyToken=71e9bce111e9429c' or one of its dependencies.

1 Answer 1

3

You're correct in that it needs access to the object model when running in Integrated Mode. In Native Mode the reports run in SSRS/SQL and not SharePoint directly. The report viewer for a native mode report is just an iframe, essentially.

In integrated mode the reports are stored within SharePoint, so SSRS needs to be able to communicate with SharePoint to get to the reports, data sources, etc. Hence the object model..

if this is a dev environment, I've heard some people being able to get around this requirement by manually installing the SharePoint assemblies, but I've never tried it personally.

Hope that helps.

5
  • Thanks this does help by confirming my assumption. Do you recall where you read this? It would be extremely helpful to have MSDN documentation handy when I propose this system change. Jan 15, 2013 at 20:13
  • This is probably the best reference I know of: msdn.microsoft.com/en-us/library/bb510781(v=sql.105).aspx. It has several different deployment options (such as installing just SSRS on the SharePoint box).
    – trpeel
    Jan 15, 2013 at 20:30
  • Yes I found this in my research, unfortunately they only explain what needs to be done and not why. Jan 15, 2013 at 21:32
  • This certainly isn't an "answer" but you may find it interesting: social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/…
    – trpeel
    Jan 15, 2013 at 22:48
  • hi ,we getting the same error when we try to access the reporting server URL in SSRS configuration. i have multiple server sharepoint 2010 farm 1 Front end serve 1 app server 1 DB sever (sql 2000 standard edition ) and i configure SSRS in DB server . i don't have sharepoint 2010 installation in my DB server also i don't have SQL in my front end server . im not sure how /what will be the best option for set up SSRS sharepoint integrated mode for my environment . . Sep 21, 2015 at 11:59

Your Answer

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

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