Work with SQL Server versions

The installation workflow will vary depending on whether or not SQL Server is already installed. The version of SQL Server that is installed can also make a difference in the workflow. If SQL Server is not already installed, the System Platform installation program will install SQL Server 2022 Express Core. This is adequate for small configurations, but not for medium and large configurations. For these, install SQL Server before installing System Platform. The following workflow scenarios are described:

• SQL Server not found on node: small configuration

• SQL Server not found on node: medium and larger configurations

• Compatible version of SQL Server already installed

• New (untested) version of SQL Server already installed

• Incompatible version of SQL Server already installed

  Note: Nodes are defined as follows: Small = up to 25,000 I/O per node; Medium = 25,000 to 50,000 I/O per node; Large = 50,000 to 400,000 I/O per node.