PI AF collective cannot be created when SQL Server Agent is not running

You attempt to create a collective by right-clicking a PI AF server in AF Collective Manager, and selecting Create Collective. If the SQL Server Agent service for the selected PI AF server is not running, a message displays, indicating the SQL Server Agent is not running on the PI AF SQL database computer.

1. Click OK to return to the list of PI AF servers.

2. Start the SQL Server Agent service on the primary server, then create the new collective.

You attempt to create a collective by right-clicking in AF Collective Manager, and an error window opens, along with the Create New Collective – Finishing window, indicating:

SQL Server Agent is not running.

3. Click OK to exit the error window.

4. In the Create New Collective – Finishing window the same message appears. Click Cancel to exit the window.

   The collective was not created.

5. Start the SQL Server Agent service on the primary server, then create the new collective.