Windows Server AppFabric Persistence Store Configuration Dialog Box

  • Article

This page enables you to configure the persistence provider, including adding the persistence store registration to the configuration file, initializing the persistence store, defining the connection string to the persistence store, and configuration security settings for the persistence store.

Configure AppFabric Persistence Store

Field

Description

Register AppFabric persistence store in root web.config

Check to register the persistence store identified by the connection string, by adding its configuration to the root Web.config file. This includes the ApplicationServerWorkflowInstanceStoreConnectionString and its related persistence behavior. You can check this check box even if Initialize persistence store is not checked. Do so if the database is already created and initialized, or to point to the database even if it is not initialized. This checkbox is disabled if the Hosting Administration tools are installed, but the Hosting Services feature is not installed.

Initialize persistence store

Check 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 checked, but Register AppFabric persistence store in root web.config is not checked, then the database will be created, if necessary, and initialized, but it will not be available for use from this computer. The initializing operation is performed by the initialization cmdlets. For more information, see the AppFabric core help. For the database to be created, you must have permissions to create databases on the destination server.

Connection String

The following controls specify the connection string to be used to access the persistence store.

Field

Description

Name

The name of the connection string for the SQL persistence store. For this release, you can only use the connection string for the SQL monitoring provider. Its name by default is ApplicationServerWorkflowInstanceStoreConnectionString and cannot be changed. The connection string name is registered in the root Web.config file.

Server

Enter the name of the computer that the database is on.

Database

Enter the name of the database to be created for persistence data, or select an existing database from the list.

Security Configuration

The following controls specify the security that will be used for the persistence store.

Note

When you have installed only Hosting Administration, and you are initializing the persistence SQL store with Windows authentication, no group or user is entered by default for the Administrators, Readers, or Users role. You will need to click Browse and enter a group or user manually for each role before proceeding with the configuration.

Field

Description

Windows authentication

Select to specify that Windows authentication will be used for the persistence store.

Administrators

Click Browse and use the standard Select User or Group dialog box to enter a different value for the Administrators role. You can change the value for administrators only if Initialize persistence store is selected. By default, AS_Administrators is entered for the Administrators role.

Readers

Click Browse and use the standard Select User or Group dialog box to enter a different value for the Readers role. You can change the value for readers only if Initialize persistence store is selected. By default, AS_Observers is entered for the Readers role.

Users

Click Browse and use the standard Select User or Group dialog box to enter a different value for the Users role. You can change the value for users only if Initialize persistence store is selected. By default, BUILTIN\IIS_USRS is entered for the Users role.

SQL Server authentication

Select to specify that SQL authentication will be used for the persistence store.

User name

Enter a user name that is valid for SQL Server authentication.

Password

Enter a password that is valid for SQL Server authentication.

Keyboard Shortcuts

The following keyboard shortcuts are available for this page:

  • Register AppFabric persistence store in root web.config: Alt+r

  • Initialize persistence store: Alt+i

  • Name: Alt+n

  • Server: Alt+v

  • Database: Alt+t

  • Windows Integrated: Alt+w

  • Administrators Browse: Alt+b

  • Readers Browse: Alt+r

  • Users Browse: Alt+o

  • SQL Server: Alt+s

  • User Name: Alt+u

  • Password: Alt+p

  • Help: F1

  • OK: Enter

  • Cancel: Esc