Set‑SqlDscRSDatabaseTimeout - dsccommunity/SqlServerDsc GitHub Wiki

Sets the database timeout settings for SQL Server Reporting Services.

Set-SqlDscRSDatabaseTimeout -Configuration <Object> -LogonTimeout <Int32> [-PassThru] [-Force]
 [-WhatIf] [-Confirm] [<CommonParameters>]

Set-SqlDscRSDatabaseTimeout -Configuration <Object> -LogonTimeout <Int32> -QueryTimeout <Int32> [-PassThru]
 [-Force] [-WhatIf] [-Confirm] [<CommonParameters>]

Set-SqlDscRSDatabaseTimeout -Configuration <Object> -QueryTimeout <Int32> [-PassThru] [-Force]
 [-WhatIf] [-Confirm] [<CommonParameters>]

Sets the database logon timeout and/or query timeout for SQL Server Reporting Services or Power BI Report Server by calling the SetDatabaseLogonTimeout and/or SetDatabaseQueryTimeout methods on the MSReportServer_ConfigurationSetting CIM instance.

At least one of LogonTimeout or QueryTimeout must be specified. Both can be specified together to set both values in a single call.

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

Get-SqlDscRSConfiguration -InstanceName 'SSRS' | Set-SqlDscRSDatabaseTimeout -LogonTimeout 30

Sets the database logon timeout to 30 seconds.

Get-SqlDscRSConfiguration -InstanceName 'SSRS' | Set-SqlDscRSDatabaseTimeout -QueryTimeout 120

Sets the database query timeout to 120 seconds.

Get-SqlDscRSConfiguration -InstanceName 'SSRS' | Set-SqlDscRSDatabaseTimeout -LogonTimeout 30 -QueryTimeout 120

Sets both the database logon timeout and query timeout.

$config = Get-SqlDscRSConfiguration -InstanceName 'SSRS'
Set-SqlDscRSDatabaseTimeout -Configuration $config -LogonTimeout 30 -QueryTimeout 120 -Force

Sets both timeout values without confirmation.

Get-SqlDscRSConfiguration -InstanceName 'SSRS' | Set-SqlDscRSDatabaseTimeout -LogonTimeout 0

Sets the database logon timeout to 0 (no timeout).

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: Named
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

Specifies the default timeout value, in seconds, for report server database connections. A value of 0 means no timeout.

Type: Int32
Parameter Sets: LogonTimeout, BothTimeouts
Aliases:

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

If specified, returns the configuration CIM instance after setting the timeout values.

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

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

Specifies the default timeout value, in seconds, for report server database queries. A value of 0 means no timeout.

Type: Int32
Parameter Sets: BothTimeouts, QueryTimeout
Aliases:

Required: True
Position: Named
Default value: 0
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.

The Reporting Services service may need to be restarted for the changes to take effect.

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

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