After installing a new SharePoint Web Frontend you receive a “normal” ASP.NET error message the address in the browser will point to the _Layouts “directory”, so SharePoint is in play.
When studying the event log the message contains “Could not load file or assembly RSSharePointSoapProxy…”
This is a Assembly that is used by the SQL Server Reporting Services Integration for SharePoint.
The problem: Reporting Services is installed on the SharePoint Farm and the binaries does not exist on the new frontend server.
Solution:
Start by downloading the Microsoft SQL Server Reporting Services Add-in for Microsoft SharePoint Technologies for SQL 2005 or SQL 2008 (May 2009 release) (SharePointRS.msi or RSSharePoint.msi)
Note: The description below is based on the 2008 version of the Add-in
Do not run the MSI as a ordinary setup process, this will result in a error message in the event log and a rollback of the package. The error indicates that the SERVERNAME$ can not logon to the database.
Start the MSI with the parameter SKIPCA=1 this will extract the file rsCustomAction.exe to the TEMP folder of the current user.
To install the binaries and configure the Reporting Services run rsCustomAction.exe /i
Be sure to run as a user that has rights to the SharePoint Site Collection.
After the executable finishes your new SharePoint Front End should display the SharePoint sites normally.
By running this application the Solution will be redeployed on the existing servers as well, even upgraded if possible.
For more information see the readme bundled with the Add-in
No comments:
Post a Comment