Post-installation tasks for Amazon Relational Database Service (RDS)

After installing PI SQL Data Access Server RTQP, complete the following steps in order to grant the appropriate permissions on the SQL Server and assign the db_AFQueryEngine role to the user.

1. Connect to the Amazon RDS instance as the domain user that ran the setup.

2. Create a login and a user for the AFQueryEngine group:

   CREATE LOGIN [<domain>\AFQueryEngine] FROM WINDOWS WITH DEFAULT_DATABASE = [<AFDatabaseName>]

   USE [<AFDatabaseName>]

   CREATE USER [<domain>\AFQueryEngine] FOR LOGIN [<domain>\AFQueryEngine]

3. Add the db_AFQueryEngine role to the user:

   USE [<AFDatabaseName>]

   ALTER ROLE db_AFQueryEngine ADD Member [<domain>\AFQueryEngine]