In this article, I would like to address the issue with SSRS after downgrading SQL server version from Enterprise to Developer edition.
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:
As it shows the issue is, SSRS SQL service version is not matching with SQL server version matching with SharePoint 2013.
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.
Install the SQL RS add-in with developer version and restart all the SQL services.
For more information, please find the below MSDN article explaining about the same issue.
Hope this helps, happy administration in SharePoint 2013 !!!
Download FREE SharePoint 2019 Installation PDF Guide
This FREE PDF contains, Steps by step guide to install SharePoint 2019 Preview, prerequisites, hardware and software new features. First impression to SharePoint Server 2019 new modern site, modern lists and modern document libraries.