Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Use the SQLcm Configuration Wizard for the Agent RDS configuration or create one from the AWS console

Create an Option Group from the AWS console

. Login to your AWS account and follow the steps below:

  1. In the main navigation pane, select the Options groups from the sidebar menu. 
  2. In the Create option group window, fill out the Option group details by providing a Name, Description, and by selecting the database Engine type and VersionClick Create.
  3. Next, select the created Option Group and select Add option
  4. In the S3 destination section, fill out the required S3 Bucket information. 
  5. Next, choose the Create a New Role option, and provide a name for the IAM role.
    1. Make sure to check the permissions policies for the IAM role.
  6. In the Additional configuration section, make sure to enable the compression and retention options. 

...

  1. Select the Database option from the sidebar menu, and in the Database options section, select the recently created option group from the Option group dropdown menu. 
  2. Finally, in the Manage IAM roles section, select the role for the instance. 


Note
titleImportant notes on RDS auditing
  • RDS does not support the Middle East (Bahrain) region and works only with SQL Server versions 2012 and above.
  • The Max File Size for SQL Audit on the RDS instance limit is 50 MB.
  • Before and After Data is not supported on the RDS instance due to the limitation of creating trusted assemblies using sql script. BAD operations are removed from the properties, reports, alerts, and summary tabs.

...