How to configure SharePoint Services 3.0 Integration with Reporting Services 2008

Question

I have installed the Windows SharePoint Services 3.0 to the Reporting Service 2008 using SQL08 Ent.  In the Reporting Services Configuration Manager, I don’t see Share Point Integration button as a SSRS 2005.

I have tried install a new instances of SSRS08, but during the installation.  The option to install the new instance of SSRS as Sharepoint Integration is grey out.

How do I install SSRS 2008 with Sharepoint integration?

Answer 1

when you install sql reporting services select install but configure later.  Once installed you must use the reporting services configuration tool to configure for sharepoint integrated mode.

Also make sure you install the correct version of the add in for 2008:  http://www.microsoft.com/downloads/details.aspx?FamilyID=200fd7b5-db7c-4b8c-a7dc-5efee6e19005&displaylang=en

also more information can be found in the sharepoint business intelligence forum...which they probably will move this post to.

Answer 2

Is the "reporting services configuration tool" the same as the report services configuration Manager?


From the Report Services Configuratino Manager in SQL08 box, I can't locate a place for sharepoint integration.  Sharepoint Integration is on my other SQL05 box.  matter of fact, on the 05  box, it says, the RS instance support SP integration, but it currently runs in native mode. ... open Database SEtup page and cerate or select report server database that can be used with a SP Web App....

Thanks for the links. here is a April 2009 release of the stuff.
http://www.microsoft.com/downloads/details.aspx?familyid=58EDD0E4-255B-4361-BD1E-E530D5AAB78F&displaylang=en#filelist

thanks for your help and pointers.

Answer 3

I wonder if i should update the add-in to the april 2009, as i think i used the one i posted.

yes it is the report services configuration manager.
I used this to help me with the install.

http://mosshowto.blogspot.com/2009/03/reporting-services-sharepoint-multiple.html

there is a step to create the report db you have the option for native or sharepoint mode.

Answer 4

I have deleted your duplicate post that was posted directly to the BI forum.

NEVER post the same question more than once. Posting the same thing to two or more forums just wastes everyone's time.

---

FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
Complete Book Lists (incl. foreign language) on each site.

Answer 5

thanks for the steps. they are very detail and very clear which is what i am looking for.

Are things the same if it was done using 3 name instances vs. 3 servers? 

my install so far is on 2 name instances; and failing.  The SSRS integrated for SP doesn't talk to the http://myserver:80/reportserver.  i've got a 404 (page unknown) while RS config tool shows things are running.  yea, the SSRS created the Sharepoint database, ReportServer, in the name instance of the SQL server.  That name instance has its own SSRS running native.  This sSRS is using the default instance.

So basically I have the following topo.

SQL Server             Report Server                             SSRS database location and name
=========         ===================       =======================
myMSsql\BIG           Native                                         myMSsql\BIG  ReportServer$BIG
<none>                   Integrated with Sharepoint            myMSsql\BIG  ReportServer

thanks.



Okay, after removing the old install and putting the new install.

I have SSRS08, SQL08, WSS3.0 SP2, April relase of Reporting Services Add-in.  I have activate RS feature in SP.

I don't find Reporting Services section in Application Management Tab as in

3.6 - Step 6: Installation of SQL Server Reporting Services 2008 Add In for SharePoint on SHAREPOINT2007, Configuration and Check.

01 - Installation of SQL Server Reporting Services 2008 Add In for SharePoint on SHAREPOINT2007

when I do http://wca-cmp-rpt2/reportserver

I've got the following error:
"
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 System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Reflection.Assembly.CreateInstance(String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at Microsoft.ReportingServices.Diagnostics.Globals.<>c__DisplayClassf.<CreateInstance>b__e() at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.<>c__DisplayClass1.<Run>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.RunInternal(SecurityContext securityContext, ContextCallback callBack, Object state) 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)
"

Answer 6

Hi light_wt,

 

It seems that the error message is related to security issue. When you configure SSRS 2008, I suggest you read the article below:

SSRS 2008 integrated mode: Security

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

 

Hope this helps.

 

Lu Zou