Remove‑SqlDscRSUnattendedExecutionAccount - dsccommunity/SqlServerDsc GitHub Wiki

Removes the unattended execution account from SQL Server Reporting Services.

Remove-SqlDscRSUnattendedExecutionAccount [-Configuration] <Object> [-PassThru] [-Force]
 [-WhatIf] [-Confirm] [<CommonParameters>]

Removes the unattended execution account from SQL Server Reporting Services or Power BI Report Server by calling the RemoveUnattendedExecutionAccount method on the MSReportServer_ConfigurationSetting CIM instance.

After removing the unattended execution account, reports that require credentials but have no user context (such as scheduled subscriptions with data sources that require credentials) will fail.

The configuration CIM instance can be obtained using the Get-SqlDscRSConfiguration command and passed via the pipeline.

Get-SqlDscRSConfiguration -InstanceName 'SSRS' | Remove-SqlDscRSUnattendedExecutionAccount

Removes the unattended execution account from the Reporting Services instance.

Get-SqlDscRSConfiguration -InstanceName 'SSRS' | Remove-SqlDscRSUnattendedExecutionAccount -Force

Removes the unattended execution account without confirmation.

Get-SqlDscRSConfiguration -InstanceName 'SSRS' | Remove-SqlDscRSUnattendedExecutionAccount -PassThru

Removes the unattended execution account and returns the configuration CIM instance.

Specifies the MSReportServer_ConfigurationSetting CIM instance for the Reporting Services instance. This can be obtained using the Get-SqlDscRSConfiguration command. This parameter accepts pipeline input.

Type: Object
Parameter Sets: (All)
Aliases:

Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByValue)
Accept wildcard characters: False

If specified, suppresses the confirmation prompt.

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False

If specified, returns the configuration CIM instance after removing the unattended execution account.

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False

Prompts you for confirmation before running the cmdlet.

Type: SwitchParameter
Parameter Sets: (All)
Aliases: cf

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type: SwitchParameter
Parameter Sets: (All)
Aliases: wi

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

After removing the unattended execution account, scheduled reports and subscriptions that rely on this account may fail.

https://docs.microsoft.com/en-us/sql/reporting-services/wmi-provider-library-reference/configurationsetting-method-removeunattendedexecutionaccount