The database engine instance you selected is not valid for this edition of reporting services

by

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
the database engine instance you selected is not valid for this edition
The Database Engine does not meet edition requirements for report data sources or the report server database
the database you have selected is not a report server database

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.

the database engine instance is not supported in this edition of reporting services
the database engine instance you selected is not valid for this edition of report server

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

the database you have selected is not a report server database
the database engine instance you selected is not valid for this edition of reporting services

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

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.

You may like the following tutorials:

>