Showing posts with label Reporting Services. Show all posts
Showing posts with label Reporting Services. Show all posts

Thursday, November 13, 2014

Install or Uninstall the Reporting Services Add-in for SharePoint



Install or Uninstall the Reporting Services Add-in for SharePoint (SharePoint 2010 and SharePoint 2013)


Run the installation package Microsoft SQL Server Reporting Services Add-in for SharePoint products (rsSharePoint.msi) on SharePoint servers to enable Reporting Services features within a SharePoint deployment. Features include Power View, a Report Viewer Web Part, a URL proxy endpoint, content types, and application pages so that you can create, view, and manage reports, report models, data sources and other report server content on a SharePoint site. The Reporting Services Add-in for SharePoint products is a required component for a report server that runs in SharePoint mode. The add-in can be installed from either the SQL Server 2014 setup wizard or by downloading the rsSharePoint.msi from the SQL Server 2014 feature pack

Very good article from MS.


  http://msdn.microsoft.com/en-us/library/aa905871.aspx


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Monday, August 11, 2014

The feature: "windows SharePoint services integration" is not supported in this edition of Reporting Services



The feature: "windows SharePoint services integration" is not supported in this edition of Reporting Services

Environment: SharePoint 2013, SQL 2012 Reporting Services

Description: After setting up and configuring SSRS in SharePoint 2013; Once you navigate to Reporting Services Service Application and click on the Settings link you might see below error:

Error: The feature: "Windows SharePoint Services integration" is not supported in this edition of Reporting Services. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Windows SharePoint Services integration" is not supported in this edition of Reporting Services.

Solution: If this happens make sure you have the right SQL 2012 edition for the Reporting Services and Add-ins on the SharePoint server. 

For this navigate to Reporting Services log files location: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\WebServices\LogFiles\

Check for the following string in the log files:

"INFO: Reporting Services starting SKU: Express"
If you are able to find this line then it signifies that you have the wrong edition (i.e. SQL Express) on the server. SQL Express edition does not support Reporting Services integration and Power Pivot integration with SharePoint 2013.

To fix the issue:

Uninstall the existing SQL 2012 bits from the server. You can do that via control panel - add remove programs. Select SQL Server and then uninstall it.

Install SQL 2012 Enterprise/Standard now and follow the SSRS integration steps (running the PowerShell cmdlts and creating the Service Application).

How to configure the SSRS: http://expertsharepoint.blogspot.de/2014/03/sql-reporting-services-installation.html

MS article: http://technet.microsoft.com/en-us/library/ee384252%28v=sql.100%29.aspx

 

I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Wednesday, June 18, 2014

Could not load file or assembly 'RSSharePointSoapProxy



Could not load file or assembly 'RSSharePointSoapProxy

                       

Initially, when I start the Central administration page, I welcomed with the error” the page can’t found”. After I enabled the Call stack and custom errors mode to see the Exact error. The error should be below.

Issue: Could not load file or assembly 'RSSharePointSoapProxy, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'RSSharePointSoapProxy, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Cause: The issue happens because of missing or corrupted RSSharePointSoapProxy dll due to un-installation of Reporting Services Add-In.

Solution: To get resolve the issue, we need to re-install the missing RSS files. 

Download the Microsoft® SQL Server® 2008 R2 Reporting Services Add-in and install in the server.

Link: http://www.microsoft.com/en-us/download/confirmation.aspx?id=622

Note:No need to reboot server or Restart of any service after installation of RSS Add on.
 

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Tuesday, June 10, 2014

Reporting Web service proxy Does not exist in the farm



Reporting Web service proxy Does not exist in the farm

Issue: After we configure Everything related to Reporting services for SharePoint 2013,when we try to create the reporting service application in CA, we encounter the issue “Reporting Web service proxy Does not exist in the farm”

                    

Cause: The issue is due to the reporting features are installed but not configured the reporting services and the proxy in CA. 

Solution: Ensure to run the below commands to get rid of the error.we must run the below two commands before creating the SSRS service application in CA.

Install-SPRSService
Install-SPRSServiceProxy

You can find the very detailed explanation in the below Article.

http://expertsharepoint.blogspot.de/2014/03/sql-reporting-services-installation.html
 

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

ShareThis

X