In this SharePoint tutorial, we will discuss, how to solve an error the database engine instance you selected is not valid for this edition of reporting services. The Database Engine does not meet edition requirements for report data sources or the report server database.
Here, I would like to address the issue with SSRS after downgrading the SQL server version from Enterprise to Developer edition.
My client has downgraded the SQL server associated with SharePoint from the Enterprise version to the development version. Soon they completed this change SSRS services stopped working and we were getting the below issue:
The database engine instance you selected is not valid for this edition of reporting services
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 the developer version and restart all the SQL services.
For more information, please find this MSDN article explaining the same issue.
You may like the following SharePoint tutorials:
- SharePoint 2010 to SharePoint 2013/2016/2019 Migration Steps
- SharePoint content database tutorial
- Shrink SharePoint config database transaction log files
- Backup and Restore content database SharePoint 2013
- Cannot connect to the configuration database error in SharePoint
- Configure Excel Service Application in SharePoint
- Get-SPFarm : The term Get-SPFarm is not recognized as the name of a cmdlet, function, script file or operable program error in PowerShell ISE in SharePoint 2013
In this tutorial, we learned how to solve an error the database engine instance you selected is not valid for this edition of reporting services. The Database Engine does not meet edition requirements for report data sources or the report server database.
I am Krishna.Vandanapu a SharePoint architect working in IT from last 13+ 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