Adding new data source connection only contains sql server in dropdown in SSRS 2016


I just installed SQL Server 2016 Express and was going to add an ODBC connection to my SSRS instance. When I went to the dropdown to change the connection type from SQL Server to DB2, the only connection type available in the dropdown is SQL Server.

Anyone know how to fix this? Is this a limitation in the Express version?

Best Answer

It is a limitation that you are hitting for Reporting Services in SQL Server Express

Report data sources must be SQL Server relational databases that run locally in SQL Server Express.