Share via

SSRS 2017 Express

ABE 26 Reputation points
2021-01-07T20:22:47.647+00:00

Question: Do I need to purchase a license to use SSRS 2017 Express? Is Express just for Development or can I use this for Production?

https://learn.microsoft.com/en-us/sql/reporting-services/reporting-services-features-supported-by-the-editions-of-sql-server-2016?view=sql-server-ver15#edition-requirements-for-the-report-server-database

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,066 questions
SQL Server | Other
0 comments
Accepted answer
  1. Mohamed El-Qassas 1,401 Reputation points MVP Volunteer Moderator
    2021-01-07T20:51:48.767+00:00

    First, you should be aware of SQL Server Express with Tools and SQL Server Express don't support SQL Server Reporting Services. However, you can use the Express with Advanced Services edition.

    Second, the Express edition is free, but the Express with Advanced Services edition requires to join the Visual Studios Dev Essentials program.

    Third, regarding using Express on production, Yes, but it's not recommended because it has some limitations that for sure will not fit the production deployment, so it mainly depends on your requirements.

    See Also

    2 people found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,496 Reputation points
    2021-01-08T02:04:02.15+00:00

    Hi @ABE ，

    Note that SQL Server Express with Tools and SQL Server Express don't support SQL Server Reporting Services.

    SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).

    SQL Server Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications.

    SQL Server Developer edition lets developers build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. SQL Server Developer is an ideal choice for people who build and test applications.

    It is not suggested to use SQL Server Express for Production. If you want to use SQL Sever for Production, you need to purchase a license for SQL Sever Standard or SQL Sever Enterprise depends on your needs.

    editions-and-components-of-sql-server-2017

    sql-server-2019-pricing

    If you just want to use SSRS in test environment, both SQL Express with Advanced Services edition or SQL Sever Developer edition is enough.

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.