SSRS version conflict issue in SharePoint2013

sharepoint 2013 ssrs reports not working

In this article, I would like to address the issue with SSRS after downgrading SQL server version from Enterprise to Developer edition.

Issue:


My client has downgraded SQL server associated with SharePoint from Enterprise version to the development version. Soon they completed this change SSRS services stopped working and we were getting below issue:

sharepoint 2013 ssrs reports not working
sharepoint 2013 ssrs reports not working
sharepoint 2013 ssrs reports version conflict issues

As it shows the issue is, SSRS SQL service version is not matching with SQL server version matching with SharePoint 2013.

Solution

Follow the below 2 steps to fix this issue:

Log on to the server where SSRS SQL service is installed and uninstall “Microsoft SQL Server 2014 RS Add-in for SharePoint” as part of the installed programs.

uninstall sql server reporting services 2013
uninstall sql server reporting services 2013

Install the SQL RS add-in with developer version and restart all the SQL services.

sql server 2014 reporting services add-in for sharepoint 2013
sql server 2014 reporting services add-in for sharepoint 2013

For more information, please find the below MSDN article explaining about the same issue.

https://blogs.msdn.microsoft.com/psssql/2013/02/20/rs-database-engine-does-not-meet-edition-requirements/



Hope this helps, happy administration in SharePoint 2013 !!!

Check out Best Alternative to InfoPath -> Try Now

You May Also like the Following SharePoint Online Tutorials:

About Krishna Vandanapu

I am Krishna.Vandanapu a SharePoint architect working in IT from last 12 years, I worked in SharePoint 2007, 2010, 2013, 2016 and Office 365. I have extensive hands on experience in customizing SharePoint sites from end to end. Expertise in SharePoint migration tools like Sharegate, Doc Ave and Metalogix. Migrated SharePoint sites from SharePoint 2007 to 2010 and 2010 to 2013 several times seamlessly. Implementing CSOM with Microsoft best practices. Spent quality time in configuring SharePoint application services like User Profile, Search, Managed Meta data services etc. Now exploring SharePoint Framework and SharePoint 2019

View all posts by Krishna Vandanapu →