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.

No comments:

Post a Comment

Your feedback is Much Appreciated. I will try to reply to your queries as soon as possible!!Anil Avula

ShareThis

X