PI AF collectives in a domain or workgroup

Any PI AF server (a computer where the PI AF application service is installed) in a PI AF collective must be in a domain; workgroups are not supported.

The PI AF SQL database computers can be in a workgroup or a domain.

If the PI AF SQL database computers are in a workgroup, you must use a local Windows account that exists on the computer where AF Collective Manager is run to create the collective on the SQL Server computer. The accounts must have matching passwords, be in the local Windows administrators group on all computers, and be a member of the SQL Server sysadmin role. This local account will be used to run AF Collective Manager and create the PI AF collective.

Note: If you run AF Collective Manager as a domain account that is mapped to sysadmin in SQL Server but your SQL Server is in a workgroup, you will get this error: cannot open service control manager on computer '172.30.86.10'. This operation might require other privileges. Do you wish to continue?