Database Configuration

  • Article

Applies To: Opalis 6.3

The Database Configuration utility prepares the database where Opalis Integration Server stores information about your policies. This database is called the datastore. You also use the Database Configuration utility to make changes to the datastore after you have installed Opalis Integration Server.

The Database Configuration utility creates the connection settings that will be used by either the management server or action server installed on the computer. It stores the settings in settings.dat, which is an encrypted file. This file is also configured with ACL permissions so that only Local Administrators or the user who ran the Database Configuration utility on the computer can access it. If this file is missing or the permissions have been changed, the management server or the action server may report errors that a connection to the datastore cannot be made. If you have changed your database settings, such as the port, user account access, or computer where it is installed, you will need to re-run the Database Configuration utility on the management server and all action servers.

Opalis Integration Server supports the versions of SQL Server that are listed in the Opalis System Requirements section. management servers and action servers that are installed on the same computer must be configured to use the same datastore. You can use a database that is running on a 64-bit operating system if the server on which that database is running is on a separate computer from the Opalis Integration Server installation.

Perform the applicable procedure for your database: "Configuring the Datastore to use SQL Server" or "Configuring the Datastore to use Oracle Server". If you are currently using Oracle Server and are upgrading to Opalis Integration Server 6.3, see the "Configuring the Datastore to use Oracle Server" section in the Opalis Administrators Guide version 6.2.

Configuring the Datastore to use SQL Server

To configure the Datastore to use SQL Server

  1. Assign the SQL Server roles Database Creators and Setup Administrators to the Service User account.

  2. On the Install Opalis Integration Server dialog box, click Configure the Datastore. The Database Configuration dialog box appears. To configure the datastore after you have installed Opalis Integration Server, click Database Configuration on the Start > Programs > Opalis Software > Opalis Integration Server menu.

  3. On the Type tab of the Database Configuration dialog box, click Microsoft SQL Server and then click Next. The Server Details dialog box appears.

  4. In the Server box, click the ellipsis button (...) and select the Server from the list, or type the name of the server that is running the SQL Server database that will host the datastore. Do not enter localhost or 127.0.0.1. To specify the fully qualified database server name, type TCP:<server>\<instance>,<port> replacing server, instance, and port with the applicable values for your Microsoft SQL Server database.

    Important

    Microsoft SQL Server is usually installed on the default port 1433 and the default instance is used. In this case, the database name that you enter in the Server box of the Database Configuration utility is the computer name, for example, MYSQLSERVER.

    In some cases, Microsoft SQL Server may be installed on a named instance. In this case, you enter both the computer name and the instance name in the Server box of the Database Configuration utility in the following format: computer name\instance, for example, MYSQLSERVER\NONDEFAULT.

    If the SQL Server uses a non-default port, you also enter the port the Server box of the Database Configuration utility, in the following format: computer name,port for the default SQL instance, or computer name\instance,port for a non-default instance. For example, MYSQLSERVER,12345 or MYSQLSERVER\NONDEFAULT,12345.

  5. Select the authentication method to use to connect to the SQL Server:

    • Windows Authentication Connect to the SQL Server using Windows authentication.

    • SQL Authentication Connect to the SQL Server using a SQL Server user account. Type the User Name and Password of the SQL Server user account. This account must have rights to create, write, and own a database as well as create, update, and delete rows in the database.

  6. Click Next. The Database Details tab appears.

  7. Select the action that you want to use to create the datastore:

    1. Create a new database Select this option to create a new management database. Type a Name for this database.

    2. Use an existing database Select this option if:

      1. You have already created a database in SQL Server that you will use as the datastore. Select the Name of the database from the list. The authentication credentials that you specified on the Server tab must have rights to create, write, and own a database as well as create, update, and delete rows in the database.

      2. You are performing a manual deployment of an action server.

  8. Click Finish. The Database Configuration utility creates the datastore. The Install Opalis Integration Server dialog box appears.

Next Step: Import a License.