SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS 2008 environment with Sharepoint integrated mode


SSRS 2008 environment with Sharepoint integrated mode

Author
Message
Mit -421214
Mit -421214
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 9812
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
Gift Peddie
Gift Peddie
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16064 Visits: 14456
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
Mit -421214
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 9812
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
Ben Sullins-437405
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1113 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...
Gift Peddie
Gift Peddie
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16064 Visits: 14456
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search