Reporting Services 2022 command line installation does not support creating an instance or database?

Question

My company's software comes bundled with (at the moment) SQL Server Express 2014 with Reporting Services. We want to upgrade to 2022 Express and are running into a few hurdles. The old 2014 installer had parameters that let SSRS create an instance and database. With a few tweaks we made with a custom console program that runs at the end of the installation, that worked well for us.

However, the new 2022 command line installation for SSRS 2022 does not appear to give you any options for creating an instance or database. At this point, short of some potential PowerShell options, the only way to get these is through the UI and we would rather not have our end customers have to deal with that, as it will likely result in support calls to us.

Am I missing anything obvious? I thought to possible create an .RSS file and have RS.exe do the work, but at this point I do not know if that is even possible. Nor do I have any documentation on how to write the VBA to do this.

Any thoughts are appreciated!

Kelly

Answer 1

Hi @Kelly Anderson-McConnell

Reporting Services supports the use of scripts to automate routine installation, deployment, and management tasks. You can refer to this document: Script Deployment and Administrative Tasks.

For RS.exe, you can check the following link: RS.exe Utility (SSRS).

Here is a sample Reporting Services rs.exe script for copying content between report servers that you can use as a reference: https://learn.microsoft.com/en-us/sql/reporting-services/tools/sample-reporting-services-rs-exe-script-to-copy-content-between-report-servers?view=sql-server-ver16.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya