# Disabling and deleting SSRS or PBIRS databases
<a name="SSRS.DisableDelete"></a>

Use the following procedures to disable SSRS or PBIRS and delete their databases:

**Topics**
+ [Turning off SSRS or PBIRS](#SSRS.Disable)
+ [Deleting the SSRS or PBIRS databases](#SSRS.Drop)

## Turning off SSRS or PBIRS
<a name="SSRS.Disable"></a>

To turn off SSRS, remove the `SSRS` option from its option group. To turn off PBIRS, remove the `PBIRS` option from its option group. Removing the option doesn't delete the report server databases. For more information, see [Deleting the SSRS or PBIRS databases](#SSRS.Drop).

You can turn SSRS on again by adding back the `SSRS` option, or PBIRS by adding back the `PBIRS` option. If you have also deleted the report server databases, adding back the option on the same DB instance creates new report server databases.

### Console
<a name="SSRS.Disable.Console"></a>

**To remove the SSRS option from its option group**

1. Sign in to the AWS Management Console and open the Amazon RDS console at [https://console.aws.amazon.com/rds/](https://console.aws.amazon.com/rds/).

1. In the navigation pane, choose **Option groups**.

1. Choose the option group with the `SSRS` option (`ssrs-se-2017` in the previous examples).

1. Choose **Delete option**.

1. Under **Deletion options**, choose **SSRS** for **Options to delete**.

1. Under **Apply immediately**, choose **Yes** to delete the option immediately, or **No** to delete it at the next maintenance window.

1. Choose **Delete**.

**To remove the PBIRS option from its option group**

1. Sign in to the AWS Management Console and open the Amazon RDS console at [https://console.aws.amazon.com/rds/](https://console.aws.amazon.com/rds/).

1. In the navigation pane, choose **Option groups**.

1. Choose the option group with the `PBIRS` option (`pbirs-se-2025` in the previous examples).

1. Choose **Delete option**.

1. Under **Deletion options**, choose **PBIRS** for **Options to delete**.

1. Under **Apply immediately**, choose **Yes** to delete the option immediately, or **No** to delete it at the next maintenance window.

1. Choose **Delete**.

### CLI
<a name="SSRS.Disable.CLI"></a>

**To remove the SSRS option from its option group**
+ Run one of the following commands.  
**Example**  

  For Linux, macOS, or Unix:

  ```
  aws rds remove-option-from-option-group \
      --option-group-name {{ssrs-se-2017}} \
      --options SSRS \
      --apply-immediately
  ```

  For Windows:

  ```
  aws rds remove-option-from-option-group ^
      --option-group-name {{ssrs-se-2017}} ^
      --options SSRS ^
      --apply-immediately
  ```

**To remove the PBIRS option from its option group**
+ Run one of the following commands.  
**Example**  

  For Linux, macOS, or Unix:

  ```
  aws rds remove-option-from-option-group \
      --option-group-name {{pbirs-se-2025}} \
      --options PBIRS \
      --apply-immediately
  ```

  For Windows:

  ```
  aws rds remove-option-from-option-group ^
      --option-group-name {{pbirs-se-2025}} ^
      --options PBIRS ^
      --apply-immediately
  ```

## Deleting the SSRS or PBIRS databases
<a name="SSRS.Drop"></a>

Removing the `SSRS` or `PBIRS` option doesn't delete the report server databases. To delete them, use the following stored procedures.

To delete the report server databases, be sure to remove the `SSRS` or `PBIRS` option first.

**To delete the SSRS databases**
+ Use the following stored procedure.

  ```
  exec msdb.dbo.rds_drop_ssrs_databases
  ```

**To delete the PBIRS databases (SQL Server 2025 and higher)**
+ Use the following stored procedure.

  ```
  exec msdb.dbo.rds_drop_pbirs_databases
  ```