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:

ParameterConfiguration Property Example Value
Host AddressserverHost

localhost or 192.168.1.50

PortportNumber

5432

Database NamedatabaseName

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

Database UserdatabaseUser

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

PassworddatabasePassword

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

SSL ConnectionuseSSL

false or true

1. Engine Installation

Back to top