Create the AgilePoint Database Schema

  1. Open IIS and view the AgilePointServer Virtual Directory. Browse the Workflow.asmx file. This creates the AgilePoint Database schema.
Note: The AgilePoint Server configuration is stored in the netflow.cfg file in the root directory of the AgilePointServer virtual directory. Additional configuration options are described in the AgilePoint System Optimization document.
Note: For security purposes, after finishing the AgilePoint Server configuration, you can remove the AgilePoint Server service account from the db_owner role in order to disallow the Create table privilege. Instead you can add this user to the db_datareader and db_datawriter role memberships. Please note that when updating the database schema in the future (e.g. for an upgrade), you will need to add this account back to the db_owner role in order for the database schema to be updated