Page History
...
The following options are available for the connection:
Windows Authentication
Allows you to set a domain\username format with Windows Username and Password credentials. This option is set as default for the connection credentials.
SQL Server Authentication
Allows you to register your SQL Server Agent credentials for the connection of the registered SQL Server.
...
| Info |
|---|
If you want to apply the Windows Authenticationoption, the SQL Server Authentication fields become gray out and usableare unusable. The same happens when selecting the SQL Server Authentication option. |
Amazon RDS for SQL Server
Specify Connection Credentials
Suppose you selected the Amazon RDS for SQL Server option in the Server Type when adding a server. In that case, the Windows Authentication is replaced with the AWS Directory Service for Microsoft Active Directory credentials for the authentication.
SQLcompliance Agent RDS Configuration
Enter the necessary Acces and Secret keys to grant the SQLcompliance Agent access to the S3 bucketBucket. Next, select a region, type in your Bucket name, and select your desired Storage Class.
Available Fields
Location Type
...
Choose a temporary location path.
Agent RDS Configuration - Option Group
Once connected, add the Option Group details by completing the SQLcompliance Agent RDS Configuration settings.
...
Select your IAM role from the dropdown list or create a new IAM Role.
Users can choose an existing or create a new IAM Role and map it to the option group and RDS instance registered.
| Note | ||
|---|---|---|
| ||
In case of any incompatibilities on AWS, remain on the screen, select the newly created IAM Role, and map it to the option group and registered RDS instance. |
IAM Role Name
Choose a unique name for the new IAM Role.
| Info | ||
|---|---|---|
| ||
Newly created IAM roles can be utilized across different SQL server versions. |
Enable Compression
Select this checkbox to enable compression.
...