Wednesday, November 5, 2014

Could not load file or assembly 'RSSharePointSoapProxy' - Solved

The error showed something to do with Reporting services and check that under general settings of CA. The following application setting was missing.

Then found that we need to downloaded and install "Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies 2010"  . Did the same and then the problems seems to be fixed. Hope this helps you!!!

Tuesday, November 4, 2014

The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded.

After I installed SSRS on SharePoint integrated mode, when I tried to configure SSRS using configuration manager I got the following error.

The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpSecurity.set_StaticCatchAccessDeniedException(Boolean value) at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelperFactory.get_ServiceHelper() 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]. . (rsSharePointObjectModelNotInstalled) .

The reason for this error is , I installed SSRS on the SQL Server, rather then installing it on the SharePoint farm. Then I corrected my mistake by installing it on the SharePoint farm. Hope this helps!!!

Sunday, November 2, 2014

SSRS native mode reports and SharePoint 2010

I am now developing SSRS reports which will be hosted on native mode. These SSRS reports will be consumed by SharePoint 2010 applications. To consume native mode SSRS reports please follow the below steps.
  1. Copy the to a folder on the SharePoint server. By default the can be found in "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint".
  2. On the SharePoint Server run the STSADM command on the file using the following syntax "STSADM.EXE -o addwppack -filename "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\" -globalinstall". -globalinstall is must if you want to create connected web parts.
After these you will be able to use Report Viewer web parts, which are under miscellaneous categories.

Hope this helps you!!!