EN
このコンテンツは設定された言語で表示できません。英語版のページが表示されます。

Create and Initialize a Database Using IIS Manager

This topic describes how to create a Monitoring or Persistence database in “Dublin”.

Creating a Persistence or Monitoring Database

Creating a persistence or monitoring database is essentially a two-step process: First, you add a connection string to identify the server and database name you want to use for your new persistence or monitoring database. Second, you initialize the new database to make it ready for use.

You must initialize a monitoring or persistence database before you can use it. During initialization, the database will be created if it does not already exist (you must have permission to create databases on the destination SQL Server). Initialization creates a schema in the database, then creates objects and assigns them to the schema. You can use dedicated monitoring and persistence databases, or the monitoring and persistence schemas can coexist in a single database container.

After you initialize a monitoring or persistence database you can use SQL Server Management Studio to view the objects in the database. You may also need to view or change the security logons for a database. “Dublin” does not provide tools to do this so you will need to use SQL Server Management Studio. For more information, see the procedure To view objects in the database.

See Remove a Database for procedures to remove databases.

Procedures

The following procedures describe how to perform the various tasks associated with creating “Dublin” databases. To perform these procedures you must be logged on using an account that is a member of the AS_Administrators group. The AS_Administrators group secures administrative access to the database, but is not used to secure access to configuration files in the local computer.

WarningWarning
These procedures require different levels of access. If you are going to initialize a database, then you must have been assigned those permissions within the database server. For an operation that impacts the machine configuration at the root level, such as adding a connection string, you must have administrative privileges.

 

Procedure Description

To add or edit a connection string

Describes how to add a new connection string, or edit an existing connection string.

To initialize a persistence database

Describes how to initialize a persistence database.

To initialize a monitoring database

Describes how to initialize a monitoring database.

To view objects in a database

Describes how to view the objects in a monitoring or persistence database.

Add or Edit a Connection String

To create a connection string
  1. In the Connections pane (left pane), in the tree view, select the server, site, or application level at which you want to define the connection string.

  2. Double-click Persistence Database Configuration or the Monitoring Database Configuration in the Features View of the Workspace pane (middle pane) to open a database configuration page.

    noteNote
    For the purpose of adding a connection string, it doesn’t matter which database configuration page you use.

  3. Click Add action from the Connection String section of the Actions pane to open the Add Connection String dialog box.

  4. Type the name for the connection string in the Name field. This does not have to be the same as the name of the database.

  5. Type the name of the SQL Server that will host your persistence or monitoring database. You can use localhost or (local) to reference the local computer.

  6. Select the Database drop-down list. If there are databases available on the server they will be shown after a brief pause to obtain the list from the server. You can enter the name of a new database to be created here. If you enter a database name that is not on the list, it will be created when you initialize the database.

  7. Click OK to apply the settings and close the dialog box. You should see the connection string in the list with status “uninitialized”. If the status of a connection is “uninitialized,” you must initialize the database before you can use it.

    For detailed description of fields in the Add Connection String dialog box, see Add Connection String Dialog Box.

To edit a connection string
  1. In the Connections pane (left pane), in the tree view, select the server, site, or application level at which you want to define the connection string.

  2. Double click Persistence Database Configuration or Monitoring Database Configuration in the Features View of the Workspace pane (middle pane) to open a database configuration page.

  3. Select the connection string you want to modify, and then click Edit to open the Edit Connection String dialog box.

    noteNote
    You can only edit a connection that is local to the scope at which you are performing the Edit operation.

  4. Update the name of the database server and/or the name of the database. You cannot change the name of the connection string itself.

  5. Click OK to apply the settings and close the dialog box.

    For detailed description of fields in the Edit Connection String dialog box, see Edit Connection String Dialog Box.

Initialize a Database

To initialize a persistence database using IIS Manager
  1. In the Connections pane (left pane), in the tree view, select the server, site, or application level at which you have defined the connection string that points to the persistence database you want to initialize.

  2. Double click Persistence Database Configuration in the Features View of the Workspace pane (middle pane) to open the Persistence Database Configuration page.

  3. In the Persistence Database Configuration page, select the connection string that points to the database you want to initialize, and then click Initialize to open the Initialize Database dialog box.

    noteNote
    You can only initialize a database for a connection string that is local to the scope at which you are performing the Initialize operation and that is in the uninitialized state.

  4. In the Initialize Persistence Database dialog box, click Browse and select the user or group you want to add to the administrators, users, and observers groups. See Security Model for Dublin for detailed information on how “Dublin” uses Windows groups and database roles to secure access to the persistence database. For detailed description of fields in the Initialize Persistence Database dialog box, see Initialize Database Dialog Box.

    noteNote
    The “Dublin” IIS Manager Extensions does not support updating the users or groups associated with “Dublin” security roles (Administrators, Users, and Observers) after the database is initialized. You will need to use the SQL Server Management Studio to do so. See To view objects in the database for details.

  5. Click OK to initialize the persistence database and close the dialog box. When you click OK, the dialog box tries to create the database on the server if the database does not already exist, runs SQL scripts to create database artifacts (for example, tables, views, and stored procedures) required by the persistence features.

    Your new persistence database is ready for use after initialization is complete. To view the objects in the persistence schema, see the procedure To view objects in the database.

To initialize a monitoring database using IIS Manager
  1. In the Connections pane (left pane), in the tree view, select the server, site, or application level at which you have defined the connection string that points to the persistence database you want to initialize.

  2. Double click Monitoring Database Configuration in the Features View of the Workspace pane (middle pane) to open the Monitoring Database Configuration page.

  3. In the Monitoring Database Configuration page, select the connection string that points to the database you want to initialize, and then click Initialize to open the Initialize Database dialog box.

    noteNote
    You can only initialize a database for a connection string that is local to the scope at which you are performing the Initialize operation and that is in the uninitialized state.

  4. In the Initialize Monitoring Database dialog box, click Browse and select the user or group you want to add to the administrators, users, and observers groups. See Security Model for Dublin for detailed information on how “Dublin” uses Windows groups and database roles to secure access to the monitoring database. For detailed description of fields in the Initialize Monitoring Database dialog box, see Initialize Database Dialog Box.

    noteNote
    The “Dublin” IIS Manager Extensions does not support updating the users or groups associated with “Dublin” security roles (Administrators, Users, and Observers) after the database is initialized. You will need to use your database server management tools to do so. See To view objects in the database for details.

  5. Click OK to initialize the monitoring database and close the dialog box. When you click OK, the dialog box tries to create the database on the server if the database does not already exist, runs SQL scripts to create database artifacts (for example, tables, views, and stored procedures) required by the monitoring features.

    Your new monitoring database is ready for use after initialization is complete. To view the objects in the monitoring schema, see the procedure To view objects in the database.

View Objects in a Monitoring or Persistence Database

After you initialize a Persistence or Monitoring database, you may need to examine the objects in the database. “Dublin” does not provide tools to view the contents of a database, so you will need to use SQL Server Management Studio.

The following table lists the names of the “Dublin” database schemas. Objects belonging to a given schema have names that begin with the schema name.

Dublin Database Schemas

Schema Name Description

dbo

The objects in this schema consitute the monitoring database.

System.Activities.DurableInstancing

The objects in this schema constitue the persistence database.

To view the objects in a database
  1. Open SQL Server Management Studio and connect to the server that hosts the monitoring or persistence database you want to examine.

  2. In the Object Explorer, expand the Databases node. Double-click the name of the monitoring or persistence database to expand the node and view the objects within.

See Also

表示: