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

If your PI AF SQL Database is hosted on Amazon RDS, complete the following pre-installation tasks:

1. Determine the authentication method.

   • Windows Integrated Security: Requires you to join the Amazon RDS instance to the same active domain as the Windows account running the RTQP service.

   • SQL Server authentication: This is not recommended because the password is stored in the configuration file for the AF Service, AfService.config.

     There are no additional steps needed if you are using this authentication method.

   Continue to the next step only if you are using Windows Integrated Security.

2. Verify that the SQL login for the domain account running the setup exists and has the correct permissions (CREATE ANY DATABASE and ALTER ANY LOGIN). It should have been set up during the PI AF Server installation and can be verified with the following query:

   SELECT

   sp.name AS LoginName,

   perm.permission_name,

   perm.state_desc

   FROM sys.server_principals AS sp

   LEFT JOIN sys.server_permissions AS perm

   ON perm.grantee_principal_id = sp.principal_id

   WHERE sp.name = '<domain>\<username>';

3. Create the AFQueryEngine domain group, and then assign the user that will run the RTQP service to this group.