DSCResources/DSC_SqlRSSetup/en-US/about_SqlRSSetup.help.txt
.NAME
SqlRSSetup .DESCRIPTION The SqlRSSetup DSC resource installs the standalone https://docs.microsoft.com/en-us/sql/reporting-services/create-deploy-and-manage-mobile-and-paginated-reports. If both SourceCredential and PsDscRunAsCredential is used then the credentials in SourceCredential will only be used to copy the installation media locally, and then the credentials in PsDscRunAsCredential will be used during installation. If PsDscRunAsCredential is not used, then the installation will run as SYSTEM. >To install Microsoft SQL Server Reporting Services 2016 (or older), >please use the resource SqlSetup. ## Requirements * Target machine must be running Windows Server 2012 or later. * If PsDscRunAsCredential common parameter is used to run the resource, the specified credential must have permissions to connect to the location where the Microsoft SQL Server Reporting Services media is placed. * The parameter IAcceptLicenseTerms must be set to 'Yes'. * The parameter InstanceName can only be set to 'SSRS' since there is no way to change the instance name. * When using action 'Uninstall', the same version of the executable as the version of the installed product must be used. If not, sometimes the uninstall is successful (because the executable returns exit code 0) but the Microsoft SQL Server Reporting Services instance was not actually removed. > [!IMPORTANT] > When using the action 'Uninstall' and the target node to begin with > requires a restart, on the first run the Microsoft SQL Server Reporting > Services instance will not be uninstalled, but instead exits with code > 3010 and the node will be, by default, restarted. On the second run after > restart, the Microsoft SQL Server Reporting Services instance will be > uninstalled. If the parameter SuppressRestart is used, then the node must > be restarted manually before the Microsoft SQL Server Reporting Services > instance will be successfully uninstalled. > > The Microsoft SQL Server Reporting Services log will indicate that a > restart is required by outputting; "*No action was taken as a system > reboot is required (0x8007015E)*". The log is default located in the > SSRS folder in %TEMP%, e.g. C:\Users\<user>\AppData\Local\Temp\SSRS. ## Known issues * https://github.com/dsccommunity/SqlServerDsc/issues/1311 All issues are not listed here, see https://github.com/dsccommunity/SqlServerDsc/issues?q=is%3Aissue+is%3Aopen+in%3Atitle+SqlRSSetup. .PARAMETER InstanceName Key - String Allowed values: SSRS Name of the Microsoft SQL Server Reporting Service instance to installed. This can only be set to 'SSRS'. .PARAMETER IAcceptLicenseTerms Required - String Allowed values: Yes Accept licens terms. This must be set to 'Yes'. .PARAMETER SourcePath Required - 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. .PARAMETER Action Write - String Allowed values: Install, Uninstall The action to be performed. Default value is 'Install' which performs either install or upgrade. .PARAMETER SourceCredential Write - Instance Credentials used to access the path set in the parameter SourcePath. .PARAMETER SuppressRestart Write - Boolean Suppresses any attempts to restart. .PARAMETER ProductKey Write - String Sets the custom license key, e.g. '12345-12345-12345-12345-12345'. This parameter is mutually exclusive with the parameter Edition. .PARAMETER ForceRestart Write - Boolean Forces a restart after installation is finished. If set to $true then it will override the parameter SuppressRestart. .PARAMETER EditionUpgrade Write - 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. .PARAMETER VersionUpgrade Write - 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. .PARAMETER Edition Write - String Allowed values: Development, Evaluation, ExpressAdvanced Sets the custom free edition. This parameter is mutually exclusive with the parameter ProductKey. .PARAMETER LogPath Write - String Specifies the setup log file location, e.g. log.txt. By default log files are created under %TEMP%. .PARAMETER InstallFolder Write - String Sets the install folder, e.g. C:\Program Files\SSRS. Default value is C:\Program Files\Microsoft SQL Server Reporting Services. .PARAMETER SetupProcessTimeout Write - 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. .PARAMETER ErrorDumpDirectory Read - String Returns the path to error dump log files. .PARAMETER CurrentVersion Read - String Returns the current version of the installed Microsoft SQL Server Reporting Service instance. .PARAMETER ServiceName Read - String Returns the current name of the Microsoft SQL Server Reporting Service instance Windows service. .EXAMPLE 1 This example shows how to install a Microsoft SQL Server Reporting Service instance (2017 or newer). Configuration Example { [CmdletBinding()] param ( [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlInstallCredential ) Import-DscResource -ModuleName 'SqlServerDsc' node localhost { SqlRSSetup 'InstallDefaultInstance' { InstanceName = 'SSRS' IAcceptLicenseTerms = 'Yes' SourcePath = 'C:\InstallMedia\SQLServerReportingServices.exe' Edition = 'Development' PsDscRunAsCredential = $SqlInstallCredential } } } .EXAMPLE 2 This example shows how to install a Microsoft SQL Server Reporting Service instance (2017 or newer). Configuration Example { [CmdletBinding()] param ( [Parameter(Mandatory = $true)] [ValidateNotNullOrEmpty()] [System.Management.Automation.PSCredential] $SqlInstallCredential ) Import-DscResource -ModuleName 'SqlServerDsc' node localhost { SqlRSSetup 'InstallDefaultInstance' { InstanceName = 'SSRS' SourcePath = 'C:\InstallMedia\SQLServerReportingServices.exe' Action = 'Uninstall' # This needs to be set to although it is not used during uninstall. IAcceptLicenseTerms = 'Yes' PsDscRunAsCredential = $SqlInstallCredential } } } |