Create a Region and Cross-Region Database for Microsoft SQL Server

Attention: This feature is in Early Adopter Product (EAP) release status. We will continue the development of additional features and provide additional interfaces via patch updates and future releases. Please contact Micro Focus SupportLine if you require further clarification.

Use these steps to create a region database, and if one does not already exist, a cross-region database. (This process also assumes that your enterprise server region is already correctly configured to run your application.)

In the table of servers on the Home page of Enterprise Server Administration, click Edit to the left in the row for the enterprise server region

Add the following environment variables to your enterprise server region:

Variable setting	Purpose
ES_DB_FH=Y	Enables the Micro Focus Database File Handler
ES_DB_SERVER=`<DB-instance-name>`	Specifies the database instance in which the resources are stored Note: The types of resources stored are determined by the feature attribute specified for the region database in the configuration file.
MFDBFH_CONFIG=`<path-filename-config-file>`	Locates the configuration file containing the list of data sources and their database types
MFDBFH_SCRIPT_DIR=`<path-to-scripts>`	Locates the stored procedures required for Enterprise Server to interact with a database

Cold-(re)start the enterprise server region.
Tip: You can cold-start a region using the /s:c option with the casstart command on the command line.

Once the region is back up and running, you can view the console log to confirm that the region and cross-region databases were created successfully - the relevant entries are prefixed DBFH.