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

Back to top