SQL Server requirements

If required for the products/roles you are installing, and if you will not be using the version of SQL Server Express supplied with System Platform, install Microsoft SQL Server before installing System Platform. It is important to take into consideration the requirements of the different versions of SQL Server. For detailed SQL Server installation instructions, refer to the Microsoft documentation and the AVEVA TechNote applicable to your version of SQL Server, available on the AVEVA Global Customer Support web site.

• Installing Microsoft SQL Server 2016
  https://softwaresupportsp.aveva.com/#/okmimarticle/docid/tn000032384

• Installing Microsoft SQL Server 2019
  https://softwaresupportsp.aveva.com/#/okmimarticle/docid/tn000032660

If no version of SQL Server is installed on your system when you install System Platform, and you install a product or role that includes either Historian Server or a Galaxy Repository, you can choose to allow System Platform to automatically install SQL Server 2022 Express Core as it installs other prerequisites.

Note: SQL Server Express is limited to use with small installations only (25,000 I/O per node or less). For information about the versions of SQL Server supported by Application Server and other System Platform products, see the System Platform Readme.

Supported SQL Server Versions

Install all cumulative updates for all versions of SQL Server. Check the AVEVA Technology Matrix for the latest updates to this list.

• SQL 2016 Express-SSMSE (SP3 plus all cumulative updates) [Microsoft support ends July 14, 2026]

• SQL 2016 Standard, Enterprise (SP3 plus all cumulative updates) [Microsoft support ends July 14, 2026]

• SQL 2017 Express Core / Express with Advanced Tools) (plus all cumulative updates) [Microsoft support ends October 12, 2027]

• SQL 2017 Standard, Enterprise (plus all cumulative updates) [Microsoft support ends October 12, 2027]

• SQL 2019 Express Core / Express with Advanced Tools) (plus all cumulative updates) [Microsoft support ends January 8, 2030]

• SQL 2019 Standard, Enterprise (plus all cumulative updates) [Microsoft support ends January 8, 2030]

• [DEFAULT] SQL 2022 Express Core / Express with Advanced Tools) (plus all cumulative updates) [Microsoft support ends January 11, 2033]

• SQL 2022 Standard, Enterprise (plus all CUs) [Microsoft support ends January 11, 2033]

To access the relevant information from the Technology Matrix, go to the Knowledge and Support Center website, select the Technology Matrix icon, and then enter the name of the System Platform product (for example, Application Server or Historian), or enter the Windows or SQL Server version you wish to use (for example, SQL Server 2022 Standard x64).

For more information about specific requirements for SQL Server configuration, see SQL Server rights requirements, or see the Microsoft documentation available online.

• A supported version of SQL Server must be installed on the computer designated as the Galaxy Repository (GR) node before you install Application Server. If you select a product or role that requires the Galaxy Repository, and SQL Server is not installed on the computer, you have the option to install SQL Server Express Core 2022.

• The GR locks the SQL Server maximum memory usage to 65% of the computer's physical memory.

• TCP/IP must be enabled on the computer hosting a SQL Server database. The TCP/IP protocol setting can be verified from the SQL Server Network Configuration under SQL Server Configuration Manager. Do the following steps to enable TCP/IP.

To enable the TCP/IP protocol for the SQL Server database instance

1. Open the SQL Server Configuration Manager.

2. In the tree pane, click SQL Server Services.

3. If any services are displayed in the results pane, verify that each service under it is in the Running state.

   If a service is Stopped, right-click the name of the service, and select Start.

4. In the tree pane, select SQL Server Network Configuration to expand it, and then select Protocols for MSSQLServer/<InstanceName>.

   If you specified the default instance during installation, the instance name will be MSSQLSERVER.

5. In the results pane, verify that each protocol is Enabled:

   • Shared Memory

   • Named Pipes

   • TCP/IP

   If Disabled appears, right-click on the protocol name and enable it.

6. In the tree pane, select SQL Native Client Configuration to expand it, and then select Client Protocols.

7. In the results pane, verify that each client protocol is Enabled:

   • Shared Memory

   • Named Pipes

   • TCP/IP

   If Disabled appears, right-click on the protocol name and enable it.

8. If you had to enable any services:

   1. Start Task Manager.

   2. Go to the Services tab.

   3. Restart MSSQLServer/<InstanceName>.