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:
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:
- Install SSRS using SharePoing Integrated mode on the SharePoint front end server.
- 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=220.127.116.11, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies.