By Andrej Hafner

2018-09-24 06:32:29 8 Comments

I have question about using SSRS 2016 on SQL server 2014

First of all, I don't have much experience with Reporting services.

Company use SQL server 2014 and they have SQL database on it (DB is around 100GB). I could install SSRS 2014 on this server (because they have licensed SQL 2014), but I want to use SSRS 2016, because SSRS 2016 has many new features (web portal, mobile reports, custom design, KPI,..).

My idea is to install SQL 2016 Express version (It's free - 10GB) to install SSRS 2016 on it, only to store this two meta ReportServer DB and then connect to this production SQL 2014 DB to create queries on it.

Is this acceptable solution? Are there any other possibilities or they must buy SQL 2016 license to upgrade their SQL?

Thank you and best regards


@Rob Farley 2018-09-24 13:08:47

SSRS Express will only connect to its own SQL Server instance as a data source. You can’t use it in the way you’re describing it. Sorry.

Related Questions

Sponsored Content

1 Answered Questions

1 Answered Questions

[SOLVED] Migrating SSRS from SQL Server 2012 to 2016

1 Answered Questions

[SOLVED] Can I use SSRS 2016 with SQL Server 2008 R2 database engine?

1 Answered Questions

[SOLVED] SQL Server 2014 Reporting Services issues

Sponsored Content