Application Server Settings

You may need to edit the OneStream Application Server Configuration so users can create and change data in the additional database tables. If other MarketPlace solutions (such as Specialty Planning) are already in the application, these adjustments may already exist.

Configure the OneStream Application Server

Be sure that the security group settings include the users who work on and set up the solution before proceeding.

NOTE: Group settings are applicable to all MarketPlace solutions; it is important to keep the group names generic.

  1. Start the OneStream Server Configuration Utility as an Administrator.

  2. Click Open Application Server Configuration File > Database.

  3. Edit the following OneStream Database Server properties:

  • Access Group for Ancillary Tables: Select a group that includes those who will access records.

  • Can Create Ancillary Tables: True

  • Can Edit Ancillary Table Data: True

  • Maintenance Group for Ancillary Tables: Select a group to edit and maintain tables.

  • Table Creation Group for Ancillary Tables: Select a group who can create tables.

  1. Restart Internet Information Server.

NOTE: The SQL Server account used for the OneStream application must have the View Server State Permission granted for System Diagnostics to access the SQL Server details.