Pre-install tasks for Amazon RDS

The following administrative tasks must be completed before installing AF Server and setting up the PI AF SQL database on Amazon RDS:

• Create a user account for the SQL login.

• Create the AF Server domain group and assign the user account to this group.

• Grant the user account permissions to create databases and modify user accounts.

Perform setup tasks for Amazon RDS

1. Open the SQL Server Management Studio application on the node that AF Server will be installed.

2. Open a query window in SQL Server Management Studio.

3. Add the domain account that will be used to run the install kit as the SQL login to the Amazon RDS Instance:

   CREATE LOGIN [<domain>\<username>] FROM WINDOWS

4. Create the domain group:

   <domain>\AFServer

5. Add the user that will run AF Service to the AF Server domain group.

6. Give the domain account, created in step 1, permission to create databases and alter the user's sign on permissions:

   USE [master] GO GRANT ALTER ANY LOGIN TO [<domain>\<username>] GO GRANT CREATE ANY DATABASE TO [<domain>\<username>] GO

   You are now ready to install AF Server and select Amazon RDS as the cloud managed host for the PI AF database. See Install PI AF server components together.