PI AF collective creation fails due to login failure

When creating a collective, the Create New Collective – Finishing window displays the following message in the top section:

Login failed for user ‘[DOMAIN]\[UserName]’.

This message indicates that the logged-on user is unable to access one of the servers included in the collective. The error is most likely related to the fact that the logged-on user does not have the correct permissions on the primary PI AF SQL database computer.

Review the Application event logs on the PI AF server and PI AF SQL database computers, beginning with the primary PI AF server, to determine which computer is receiving the connection error.

Be sure that the login account is given sysadmin privileges to SQL Server on the AF SQL database computer.