Configure folder permissions on the primary server

On the primary PI AF SQL database computer, configure permissions on the replication folder to enable the SQL Server Agent service account to have access.

1. On the primary PI AF SQL database computer, open Windows Explorer.

2. Navigate to the \repldata folder for the SQL Server instance where the PI AF SQL database is installed.

3. Right-click the \repldata folder and select Properties.

4. Click the Security tab and click Edit.

5. In the Permissions for repldata window, click Add.

6. In the Select Users, Computers, or Groups window, check that the From this location: field shows the correct domain. If not, click Location and navigate to and select the correct domain.

7. In the Enter the object names to select field, enter the name of the domain account under which the SQL Server Agent service runs.

8. Click OK.

9. In the Permissions for [SQL Agent Account Name] area of the Permissions for repldata window, select the Modify check box and ensure that all check boxes except Full control and Special permissions are selected.

10. Click OK.

11. Click OK to return to Windows Explorer.