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