SAL CustomProperty-Reusable DITA Topic (TEST)
- Last UpdatedNov 05, 2025
- 3 minute read
SQL Server is required for Application Server, InTouch, and Historian Server. We recommend that you install and configure the supported SQL Server version before you begin the System Platform installation program. If you select SQL Server Express during System Platform installation, it will be installed automatically (applicable to small installations only).
The System Platform installer will install all prerequisites. If SQL Server is not installed, SQL Server 2019 Express Core is installed automatically. If you wish to install a full version of SQL Server, exit the installation program, install a supported SQL Server version, then resume the installation.
Other considerations are:
-
Alarm DB Logger: To use the Alarm DB Logger with SQL Server Express, you need to change the default authentication mode from Windows-based to Mixed Mode.
-
SQL Server Configuration Rights: While installing InTouch HMI for System Platform, if the logged-on user performing the installation is not a SQL Server administrator, the Config SQL dialog box appears and requests SQL Server administrator credentials.
-
Maximum Server Memory: The System Platform installation process will attempt to adjust Maximum Server Memory if it has the appropriate rights to configure SQL Server. After installing SQL Server, you can download SQL Server Management Studio and use it to confirm that the Maximum Server Memory is configured to approximately 65% of the total available RAM. By default SQL Server does not clamp this setting. If you do not have SQL Server Management Studio installed, you can download it from:
-
The MSSQL Server user account is not supported for the SQL Server Service. Instead, configure SQL Server to run as the local system or Network Service account. Named instances are not supported.
-
Migrating SQL Server Versions: System Platform now requires a 64-bit version of SQL Server. Beginning with SQL Server 2016 (13.x), SQL Server is only available as a 64-bit application. Supported SQL Server versions at the time of release of System Platform 2023 R2 SP1 include:
-
SQL Server 2016 SP3 or SP3 with all cumulative updates
-
SQL Server 2017 with all cumulative updates
-
SQL Server 2019 with all cumulative updates
-
SQL Server 2022 with all cumulative updates
Important! A 32-bit version of SQL Server cannot be upgraded to a 64-bit version through SQL Server Setup. However, you can back up or detach a database from a 32-bit instance of SQL Server, and then restore or attach the database to a 64-bit instance. For more information, see Supported Version and Edition Upgrades for SQL Server 2017.
-
-
For more information and helpful procedures about upgrading/migrating SQL Server, see the following Microsoft references:
-
SQL Server Rights Requirements: SQL Server no longer automatically creates the BUILTIN\Administrators role delivered in earlier, unsupported versions SQL Server. The Application Server installation process will create the necessary operating system user group (aaAdministrators) and SQL Server role. This automated process will provide the rights required to allow operations within the Galaxy Repository without the need for blanket BUILTIN\Administrator rights. The aaAdministrators group must be present and enabled. If you accidentally delete the aaAdministrators group from the Windows operating system, you can run either of two options to restore it:
-
Run the Change Network Utility from the AVEVA folder in the Windows Start menu.
-
Run the SQL Access Configurator from the AVEVA folder in the Windows Start menu.
If you accidentally delete the aaAdministrators group from the SQL Server security logins, you must run the SQL Access Configurator to restore it. Refer to the "About the System Platform Network Account" in the Application Server User Guide for additional information.
-