Post-install steps for Amazon RDS

After a successful AF Server installation, you will need to perform some final steps to grant appropriate permissions to the user on SQL Server and also assign the AF Server role to the user on AF Server.

1. Connect to the Amazon RDS Instance as the domain user that ran the PI Server installation kit.

2. Create a login for AFServer domain group at the database level:

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

   USE [<AFDatabaseName>] GO CREATE USER [<domain>\AFServer] FOR LOGIN [<domain>\AFServer] GO

3. Edit the role used to sign on to AFServer and assign it the 'db_AFServer' role:

   USE [<AFDatabaseName>] GO ALTER ROLE db_AFServer ADD Member [<domain>\AFServer] GO