1. Prerequisites
    1. IIS
      1. Configure IIS using the following document: CPHive Server Requirements: IIS and SSL.
      2. Verify SSL certificate is installed. You cannot continue past this step otherwise.
    2. Files
      1. Download the CPHive and CPWebhooks installer ZIP files from the Red Rook FTP site.
      2. If the files were downloaded from the Red Rook -One Drive site, Right click the Zip files,access their properties, and then verify that they are "Unblocked" due to windows security restrictions: *Note the Message in the Security field that offers a "unblock" checkbox. Check this box and click apply to adjust the security restrictions on the zip files before decompressing them. 
    3. Gather the following pieces of information:
      1. A domain Windows account
        1. It must have full control permissions to Counterpoint instance folder.
        2. It must have db_owner access to the Counterpoint database.
      2. The file path to the Counterpoint instance.
      3. Name of the Counterpoint alias folder.
      4. A Counterpoint Username
      5. A Counterpoint workgroup connected to the web store in Counterpoint.
      6. Database connection string:
        1. SQL Server login with db_owner access to the Counterpoint database.
        2. This login's password.
        3. The name of the Counterpoint database's SQL Server instance.
        4. The name of the Counterpoint database.
  2. IIS - Steps to complete in IIS
    1. Unzip the CPHive folder.
    2. Move this unzipped CPHive folder to "C:\inetpub\wwwroot".
    3. Open IIS.
    4. Expand the web server.
    5. Right-click "Application Pools" and then click "Add Application Pool":
    6. Create an Application Pool named "CPHive" using the settings shown in the screen shot below:

    7. Click the "Ok" button.
    8. Right-click the CPHive Application Pool and select "Advanced Settings":
    9. Edit Application Pool's Advanced Settings:
      1. Enable 32-bit applications.
      2. Specify Windows user for Identity, gathered from the CPHive prerequisites:
    10. Click the "Ok" button.
    11. Right-click "Default Web Site" and click "Edit Bindings":
      1. Add Site Binding for "https" with port 443, and pick the SSLcertificate provided by the client: *Note* the port 443 may sometimes be defined as another arbitrary port and must be provided by the company's network team prior to installation. 443 is simply the default port for HTTPS traffic. 
      2. Click the "Ok" button.
      3. Click the "Close" button.
    12. Open the "C:\inetpub\wwwroot\CPHive" folder and modify web.config file, specifying the following pieces of information you gathered and adding them to the appropriate sections of the file:
      1. Counterpoint Top Level directory
      2. Company Alias folder name
      3. Counterpoint Username (the password needs a value but it does not need to match the user account)
      4. Counterpoint workgroup connected tot he web store record
      5. Database connection string
        1. SQL Server login username and password
        2. Database SQL Server instance name
        3. Counterpoint database name

    13. Open IIS Manager.
    14. Expand "Default web site".
    15. Right-click "CPHive" and select "Convert to Application".
    16. Select CPHive application pool created above.
  3. Modify Counterpoint database and alias folder
    1. Open the CPHive / Database Installer folder:
    2. Run the file "Deliverator.exe" by right-clicking the file and selecting "Run As Administrator":
      .
    3. Within the Deliverator installer program, you need to specify the pieces of information for the Counterpoint database connection string. Click the box to open the Wizard for creating the database connection string:


      1. SQL Login name and password
      2. SQL Server instance name
      3. Counterpoint database name.
    4. Click the "Verify" button next to the connection string to verify the Deliverator program can connect to the Counterpoint database.
    5. Click the box to bring up a window to location the Counterpoint alias folder. Find this folder and click the "Ok" button:
    6. Click the "Verify" button to make sure Deliverator can connect to the alias folder.
    7. Click the "Install" button:
    8. Note: On new (as of 2021) and fully updated systems the Deliverator.exe will throw an error when it tries to apply the SQL scripts with a message "generic object reference not set to an instance of an object".  If that happens, you just need to run the sql scripts in the order they're numbered in the scripts folder.
  4. Install WebHooks:
    1. Installing CP Webhooks
  5. Verify by opening web browser and go to this page: https://localhost/cphive/api/helloworld