Skip to main content

CONFIGURATION: MS SQL SERVER 2

This document guides IT administrators through setting up a dedicated SQL Server database instance for use as a database repository for the AVIX Server.

Overview & Prerequisites

Before configuring AVIX Server, the database engine must be installed and populated with the target database. This table demonstrates configuration properties and values from the XML configuration file  /repositories.xml at the root of the AVIX Server installation:

Parameter Configuration Property  Example Value Host Address serverHost

localhost or 192.168.1.50

Port portNumber

5432

Database Name databaseName

avix_db                 (name of SQL Server db to use for AVIX )

Database User databaseUser

postgres              (recommended: a dedicated user e.g.  avix_sqlserver as in example below)

Password databasePassword

<your-pw>           (e.g. 'verysecret' in example below)

SSL Connection useSSL

false or true

1. Engine Installation