Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS 2008 environment with Sharepoint integrated mode Expand / Collapse
Author
Message
Posted Tuesday, March 17, 2009 11:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 7:40 AM
Points: 12, Visits: 9,812
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
Post #677739
Posted Tuesday, March 17, 2009 3:01 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:39 AM
Points: 3,428, Visits: 14,438
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
Post #677912
Posted Wednesday, March 18, 2009 7:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 7:40 AM
Points: 12, Visits: 9,812
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
Post #678455
Posted Thursday, October 29, 2009 4:31 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 25, 2010 10:10 AM
Points: 297, Visits: 267
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/

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...
Post #811273
Posted Thursday, October 29, 2009 5:17 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:39 AM
Points: 3,428, Visits: 14,438
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
Post #811298
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse