Editing the Database Parameters

NOT AVAILABLE IN SAAS

The database parameters defined during the installation of the Ekran System Application Server can be changed by using the Server tray application.

To change the database parameters, do the following:

1. Right-click the Server tray icon in the Notification area, and select Database Parameters.

2. In the Database Parameters (DbSetupToolUI) application that opens, on the Metadata Storage tab, define the following parameters:

• Select the Database Type to be used for storing the data.

NOTE: Data which already exists will not be migrated.

• Enter the Host Name or IP address of the SQL server.

• For the MS SQL Server database, select the type of Authentication: SQL Server Authentication or Windows Authentication.

• When using Windows Authentication, define the User name as "domain name\user name" or "user_name@domain_name", or click Browse and select the user.

NOTE: The specified user must be added as a user to the SQL database and have the db_ddladmin, db_datareader, db_datawriter, and db_executor permissions.

• When using SQL Server Authentication, enter the SQL Server User Name and Password in the corresponding fields.

• Select the Use encrypted connection checkbox to use SSL encryption for the connection between the Application Server and the database.

NOTE: Before selecting this checkbox, a certificate for the database server first needs to be configured, and then imported as a trusted certificate on this computer.

3. On the Binary Data Storage tab, select one of the following:

• For small deployments only, the SQL Database option can be selected to store binary data received from Clients in the SQL database. In this case, all data received during monitoring will be stored on the computer with the SQL Server installed on it.

• For medium-sized and large deployments, the File System option can be selected to store the binary data received from Clients in a shared or local folder, and then define the path to the required folder:

- A shared folder location must be defined as:

\\<computer IP>\<folder path> or \\<computer name>\<folder path> (e.g. \\admin-pc\SharedFolder).

- A local folder location must be defined as:

<folder path> (e.g. C:\BinaryDataFolder).

NOTE: If the folder for storing binary data is not accessible for some reason, the monitoring data will instead be written to the local cache, and will be automatically sent to the Application Server as soon as the connection with the folder is restored. You can view information about error events on the Health Monitoring page.

• For medium-sized and large deployments, the Amazon S3-like storage option can be selected to store the binary data received from Clients in an existing Amazon S3 storage location, and then define the parameters to access the S3 storage location. More information can be found on the Configuring Ekran System to Store Binary Data in Amazon S3 page.

4. Click OK. If you are using Windows Authentication, you will be prompted to validate the database logon for the current user of the Database Parameters (DbSetupToolUI) application. For verification to be valid, make sure the Ekran System Application Server is running under the current user of the Database Parameters (DbSetupToolUI) application.

5. Restart the EkranServer service.