SSRS 2008 environment with Sharepoint integrated mode

Question

SSRS 2008 environment with Sharepoint integrated mode

Mit -421214

SSC Veteran

Points: 282
More actions
March 17, 2009 at 11:39 am

#207136

I am setting up SSRS 2008 environment with Sharepoint integrated mode. I finished the first step,"creating SSRS 2008 installation" Now i need to installed the sharepoint integration (MOSS).
I am following this document to setup my enviornment but in this document everything is installed on one server where as we have multi server enviornments.
http://mosshowto.blogspot.com/2009/02/reporting-services-2008-report.html
Enviorment Information:
1 SSRS 2008 (Newly build server with sharepoint integrated mode)
1. web front end server (MOSS 2007)
1. App Server (MOSS 2007)
1. Sharepoint Database server(MOSS 2007)
Question 1.
Do you think I need to install (Web front end) Sharepoint on the SSRS 2008 server? OR Share Point add-ins?
Question 2.
When i try to run report server URL(172.152.10.2\ReportServer) then i got this error message. I need your help .. please share your thoughts... please send me detail reply if possible...
The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. --- End of inner exception stack trace --- at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) at System.Activator.CreateInstance(Type type, Boolean nonPublic) at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at Microsoft.ReportingServices.Diagnostics.Globals.<>c__DisplayClassf. b__0(Object state) at System.Security.SecurityContext.runTryCode(Object userData) at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData) at System.Security.SecurityContext.Run(SecurityContext securityContext, ContextCallback callback, Object state) at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.Run(ContextBody callback) at Microsoft.ReportingServices.Diagnostics.Globals.CreateInstance(String assemblyName, String typeName) at Microsoft.ReportingServices.Diagnostics.Globals.get_SharePointServicingObject(). (rsSharePointObjectModelNotInstalled) Get Online Help
Thanks,
Mit

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

I don't think you could use that blog post as an installation guide however you could use these two which covers base requirements like accounts needed.

http://msdn.microsoft.com/en-us/library/bb326356.aspx

http://blogs.devhorizon.com/reza/?p=729

Kind regards,
Gift Peddie

Mit -421214 SSC Veteran Points: 282 More actions · Answer 2

I agree with you, I shouldn't use directly follow up the blog steps becuase the setup is difference then mine.

Believe me i have same type of configuration and error which you mention in your blog. I will let you know once we succeefully configured our environment.

If you want to share any other thoguths please do.. all responses are welcome.

Thanks a lot:-)

Ben Sullins-437405 SSCertifiable Points: 5397 More actions · Answer 3

Yes you will need the MOSS front end on your SSRS box. Also, when installing the SSRS 2008 add-in you might run into an issue that requires a command line install. I ran into this today and was able to solve using methods found here - http://bensullins.com/ssrs-2008-add-in-for-moss-2007/[/url]

I am at this step now but am having problems in that the custom install did not install the SSRS web parts. Anyone out there run into this before?

Cheers,

Ben Sullins
bensullins.com
Beer is my primary key...

Gift Peddie SSC Guru Points: 73570 More actions · Answer 4

The problem is related to MOSS2007 not resolving double hop permissions that is not related to SSRS but I may not run into such problems because I know Microsoft departments like to ignore Asp.net permissions resolutions in most domains.

Kind regards,
Gift Peddie