Editing the Database Parameters
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) tool pop-up window that opens, on the Parameters tab, in the Metadata Storage section at the top, define the following parameters:
• Select the type of database you want to use for storing 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 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 [email protected]_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.
3. In the Binary Data Storage section at the bottom, select one of the following:
• For small deployments, select the SQL Database option 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, select the File System option to store 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.
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) tool. For verification to be valid, make sure the Ekran System Application Server is running under the current user of the Database Parameters (DbSetupToolUI) tool.
5. Restart the EkranServer service.