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

This guide demonstrates installing and configuring SQL Server 2022 (and 2025) Express Edition.

Windows

Download the SQL Server Express edition of your choice.

Edition	Download Link
SQL Server 2025 Express	https://download.microsoft.com/download/7ab8f535-7eb8-4b16-82eb-eca0fa2d38f3/SQL2025-SSEI-Expr.exe
SQL Server 2025 Express Core	https://download.microsoft.com/download/dea8c210-c44a-4a9d-9d80-0c81578860c5/ENU/SQLEXPR_x64_ENU.exe
SQL Server 2022 Express	https://download.microsoft.com/download/5/1/4/5145fe04-4d30-4b85-b0d1-39533663a2f1/SQL2022-SSEI-Expr.exe
SQL Server 2022 Express Core	https://download.microsoft.com/download/3/8/d/38de7036-2433-4207-8eae-06e247e17b25/SQLEXPR_x64_ENU.exe

(Express Core is the SQL Server Engine only)

Winget install Microsoft SQL Server 2025 Express (v17), or 2022 Express (v16):

winget install Microsoft.SQLServer.2025.Express

winget install Microsoft.SQLServer.2022.Express

2. network configuration - verify TCP/IP

Ensure that the TCP/IP protocol is enabled so clients (e.g. AVIX Server) can connect remotely.

The SQL Server Configuration Manager will be used to verify this.

SQL Server Configuration Manager - SQL Server | Microsoft Learn

Run the tool:

or:

Expand SQL Server Network Configuration → Protocols for [Instance Name] (e.g.
Right-click TCP/IP → Enable
Restart the SQL Server service

sql server port

1433 is the default port.