Configure Persistence Stores Using the Configuration Wizard

  • Article

You can configure persistence stores either by running the AppFabric Configuration Wizard immediately after successfully running the setup wizard, or by executing the configuration wizard from the Start menu after initial installation. The following procedure provides steps to configure instance stores by using the configuration wizard.

Note

Many of the steps that are performed in the configuration wizard can be performed manually by executing an Application Server Extensions configuration cmdlet.

To configure a persistence store by using the AppFabric Configuration Wizard

  1. Open the Microsoft AppFabric 1.1 for Windows Server Configuration Wizard by clicking Start, clicking All Programs, clicking Microsoft AppFabric 1.1 for Windows Server, and then clicking Configure AppFabric.

  2. On the Before You Begin page, click Next.

  3. On the Customer Experience Improvement Program page, click Next.

  4. On the Configure Hosting Services page, use the following table to configure persistence stores, and then click Next.

    Control Description

    Set persistence configuration

    Select to select the Workflow Management service account, and to select and configure the persistence provider.

    AppFabric Workflow Management service account

    Displays the Windows logon account for the Workflow Management service. The default is NT Authority\Local Service. You cannot enter the service account in this text box, but must do so in the Select User dialog box that you access by clicking Browse.

    Note

    The security identifier (SID) of the Workflow Management service is a member of the Administrators group, and, therefore, the WMS has administrative access to the persistence database.

    Change

    If you click Browse for the Workflow Management service account, you will be able to select the user credential for system services. You can select a built-in account or enter a custom user name and password. In the Select User dialog box, select the account that you want to use for the service, and then click OK.

    Persistence provider

    Select the provider that will give access to the persistence store. All valid data providers registered in the local machine.config file will be displayed in this list.

    Important

    In this release, the only persistence data provider that you can select is sqlStoreProvider.

    Configure

    Click to set the configuration for the persistence provider.

    How to install additional Persistence providers

    You can add a persistence provider to the list of providers that you can select in the Persistence provider drop-down box. Click this link to get help on how to add a provider.

  5. If you clicked Configure for the SQL persistence provider (sqlStoreProvider) on the Configure Hosting Services page, the Microsoft AppFabric 1.1 for Windows Server Persistence Store Configuration dialog box will be displayed. The following table describes the controls in this dialog box. Use this table to configure the persistence provider, and then click OK to return to the Configure Hosting Services page. Verify that the store was initialized and registered successfully.

    Control Description

    Register persistence store registration in root web.config

    Select to register the persistence store identified by the connection string, by adding or updating its configuration to the root Web.config file. This includes the ApplicationServerWorkflowInstanceStoreConnectionString and its related SQL Store Instance entry.

    You can select this check box even if Initialize persistence store is not selected. Do so if the database is already created and initialized, or to point to the database even if it is not initialized.

    Note

    This check box is disabled if the Hosting Administration tools are installed, but the Hosting Services feature is not installed.

    Initialize persistence store

    Select to initialize the persistence database identified in the connection string, as required before it can be used. Initialization creates the database schema and the structure based upon that schema. If the database does not exist, it will be created and then initialized.

    If this check box is selected, but Register persistence store registration to root web.config is not selected, then the database will be created, if necessary, and initialized, but it will not be available for use from this computer.

    Note

    For the database to be created, you must have permissions to create databases on the destination server.

    Connection string

    String specifying the server and database used to save persistence events.

    In the Server field, enter the name of the computer that the database is on.

    In the Database field, enter the name of the database to be created for persistence data, or select an existing database from the list.

    Note

    For this release, you can only select the connection string for the SQL persistence provider. Its name by default is ApplicationServerWorkflowInstanceStoreConnectionString and this cannot be changed. The connection string name is registered in the root Web.config file. You can change the server and database in this dialog box.

    Security Configuration

    Select Windows authentication or SQL Server authentication. Windows Integrated Security is selected by default and the groups are populated with the default built-in groups.

    For Windows authentication, to change the administrators, readers, or users, click Browse and use the standard Select User or Group dialog box to enter a different value. You can change the value for administrators, observers, or writers only if Initialize persistence store is selected.

  6. After you have clicked OK in the Configure SQL Persistence Store dialog box, you will receive a pop-up message indicating that you need to verify that the Workflow Management service identity is a member of the Persistence Database Administrators role. For more information, see Securing Hosting and Persistence.

  7. After setting the persistence configuration, click Next on the Configure Hosting Services page to display the Configure Caching Service page.

  8. On the Configure Caching Service page, click Next.

  9. On the Configure AppFabric Cache Node page, click Next.

  10. On the Configure Application page, clear Start Internet Information Services (IIS) Manager , and then click Finish to close the configuration wizard.

  2012-09-12