Data Storage

AppFabric stores persistence and monitoring information in a database. Selecting default configuration options during setup will result in the creation of two SQL Server data stores, ApplicationServerMonitoring, and ApplicationServerPersistence, which are used to store persistence and monitoring information, respectively. However, you can configure additional data store for scale-out or data separation as needed by using the Configuration Tool or PowerShell cmdlets provided with AppFabric.

Database Login Accounts

When using SQL Server, AppFabric creates Windows groups and maps them to SQL Server Database Roles. These roles are used to control access to the data stored within the data store, so that only users that are members of the correct Windows group can access the data. The following table lists the default Windows groups and the corresponding SQL Server Database Roles.

Group Description SQL Database Roles

AS_Administrators

Includes all accounts that are allowed to administer AppFabric.

Monitoring Roles:

  • MonitoringDbAdmin

  • MonitoringDbReader

  • MonitoringDbWriter

Persistence Roles:

  • System.Activities.DurableInstancing.
    WorkflowManagementServiceUsers

  • System.Activities.DurableInstancing.
    WorkflowActivationUsers

  • System.Activities.DurableInstancing.
    InstanceStoreObservers

  • System.Activities.DurableInstancing.
    WorkflowAdministrators

  • System.Activities.DurableInstancing.
    WorkflowManagementSystem

    Warning

    The WorkflowManagementSystem persistence role exists in a deprecated state for all post-B1 releases.

AS_Observers

Includes all accounts that are allowed to observe events in AppFabric.

Monitoring Roles:

  • MonitoringDbReader

Persistence Roles:

  • System.Activities.DurableInstancing.
    InstanceStoreObservers

IIS_IUSRS

Note

This group is a default Windows group and is not created by AppFabric.

Includes all service accounts that can be used as application pool identities by IIS.

Persistence Roles:

  • System.Activities.DurableInstancing.
    InstanceStoreUsers

In This Section

See Also

Concepts

Monitoring Store