Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.
share|improve this question

1 Answer 1

up vote 2 down vote accepted

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.

share|improve this answer
    
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. –  SystemAccount Jan 15 '13 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 '13 at 20:30
    
Yes I found this in my research, unfortunately they only explain what needs to be done and not why. –  SystemAccount Jan 15 '13 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 '13 at 22:48

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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