Install-SqlDscReportingServices: New command proposal

[johlju]

Command proposal

The logic that installs Reporting Services in SqlRSSetup should be moved to external command.

Proposed parameters

Parameter	Mandatory	DataType	Description	Default Value	Allowed Values
IAcceptLicenseTerms	Yes	String	Accept licens terms. This must be set to 'Yes'.	None	Yes
SourcePath	Yes	String	The path to the installation media file to be used for installation, e.g an UNC path to a shared resource. Environment variables can be used in the path.	None
ProductKey	No	String	Sets the custom license key, e.g. '12345-12345-12345-12345-12345'. This parameter is mutually exclusive with the parameter Edition.	None
EditionUpgrade	No	Boolean	Upgrades the edition of the installed product. Requires that either the ProductKey or the Edition parameter is also assigned. By default no edition upgrade is performed.	None
VersionUpgrade	No	Boolean	Upgrades installed product version if the major product version of the source executable is higher than the currently installed major version. Requires that either the ProductKey or the Edition parameter is also assigned. Default is $false.	None
Edition	No	String	Sets the custom free edition. This parameter is mutually exclusive with the parameter ProductKey.	None	Development, Evaluation, ExpressAdvanced
LogPath	No	String	Specifies the setup log file location, e.g. log.txt. By default log files are created under %TEMP%.	None
InstallFolder	No	String	Sets the install folder, e.g. C:\Program Files\SSRS. Default value is C:\Program Files\Microsoft SQL Server Reporting Services.	None
Timeout	No	UInt32	The timeout, in seconds, to wait for the setup process to finish. Default value is 7200 seconds (2 hours). If the setup process does not finish before this time an error will be thrown.	None

Special considerations or limitations

This will always install an instance of Microsoft SQL Server Reporting Service with the name SSRS. This can not be changed as per design (see SQL Server Reporting Services docs).

We might need additional commands for installing Power BI Report Server (e.g Install-SqlDscPowerBIReportServer), but would be great if the commands could use same install logic. See Install Power BI Report Server.