SQL Server Software - Metasys - LIT-12012067 - Software Application - System Configuration Tool - 16.0

SCT Installation and Upgrade Instructions

Brand
Metasys
Product name
System Configuration Tool
Document type
Installation Guide
Document number
LIT-12012067
Version
16.0
Revision date
2023-10-02
Language
English

Install SQL Server on the same computer as SCT. The following Microsoft SQL Server software versions are supported for use with SCT:

Windows® 11 Pro and Windows 11 Enterprise Editions (version 21H2, 22H2) (64-bit)

  • SQL Server® 2022 Express (64-bit): version 16.0.1000.6 or later
  • SQL Server® 2019 Express CU18 (64-bit): version 15.0.4261.1 or later
  • SQL Server® 2017 Express with CU31 (64-bit): version 14.0.3456.2 or later

Windows® 10 Pro and Windows 10 Enterprise Editions versions 21H2, 22H2 (64-bit).

  • SQL Server® 2022 Express (64-bit): version 16.0.1000.6 or later
  • SQL Server® 2019 Express CU18 (64-bit): version 15.0.4261.1 or later
  • SQL Server® 2017 Express with CU31 (64-bit): version 14.0.3456.2 or later

Windows® Server® 2022 (64-bit)

  • SQL Server® 2022 Standard or Enterprise (64-bit)
  • SQL Server® 2019 CU18 (64-bit)
  • SQL Server® 2017 CU31 (64-bit)

Windows® Server® 2019 (version 1809 or later) (64-bit)

  • SQL Server® 2022 Standard or Enterprise (64-bit)
  • SQL Server® 2019 with CU18 (64-bit): version 15.0.2005.5 or later
  • SQL Server® 2017 with CU31 (64-bit): version 14.0.3238.1 or later

Before you install or upgrade your SQL Server software, consider the following information:

  • Uninstall software such as SCT and CCT before you upgrade the version of an existing SQL instance.
  • If you have a Microsoft SQL Server version installed that is no longer supported, refer to SQL Server Software Installation and Upgrade Guide (LIT-12012240) for information about how to upgrade SQL Server.

  • If your computer has SQL Server software installed, verify that the current version of SCT supports this software. Go to Verifying your computer has a supported version of SQL Server software installed.
  • A tool called the SQL Installer is provided on the License Portal with the Branch Tools download to help you install or upgrade to any supported version of SQL Server software. If you do not have this tool, refer to the SQL Server Software Installation and Upgrade Instructions (LIT-12012240) for details on how to install or upgrade SQL Server software. Refer to SQL Server Software Installation and Upgrade Instructions (LIT-12012240) if you need to apply a new service pack (SP) to an existing installation of SQL Server software because the SQL Installer does not support service pack installations.
  • Use the SQL Installer to install a full version of SQL Server software (for example, SQL Server 2019 Standard edition), you can download the install files for full Microsoft SQL Server. To use SQL Installer to install an Express version of SQL Server software (for example, SQL Server 2019 Express), download the SQL Server Express installation file from the Microsoft SQL Server Express website.
  • The SQL Installer verifies that your computer has the prerequisites you need to install SQL Server. An error message appears if a prerequisite is not present. You need to install any missing software prerequisites before continuing.

  • The SQL Installer provides an advanced mode that lets you edit the SQL Server command line options before you start the installation. You can also copy the options, paste them into a command window, and run the installation at a command prompt. However, use this method only if you are an advanced user who fully understands SQL Server software options.
  • If you are installing SQL Server software manually, do not enable the C2 audit tracing feature. With C2 audit tracing enabled, SQL Server creates a large number of operational log files that might eventually fill the hard disk and cause the server to stop responding. However, if you install MVE, the MVE installer enables the C2 audit tracing feature for you. If you want to conserve hard disk space, be sure to disable C2 audit tracing after installing MVE.
    Note: MVE is available at Metasys Release 12.0.50.
  • The SA password that you specify in the SQL Installer window must follow the rules for Microsoft complex passwords. For more information about complex passwords, refer to the Security Administrator System Technical Bulletin (LIT-1201528).
  • SQL Server installation packages no longer include Management Tools after SQL Server 2016. If you use this server, or a later version, you must manually install the SQL Server Management Studio tool. For details on how to install SQL Server Management Studio after you install SQL Server software, refer to the SQL Server Software Installation and Upgrade Instructions (LIT-12012240).
  • If you are installing server software on a server class machine, ensure SQL Server software is installed and running before you install SCT software.

  • If after you upgrade to a newer version of SQL Server software, you need to open the archive database in an older version of SQL Server software, use the Export Database option in SCT. Then import the archive that uses an older version of SQL Server software into SCT.

If your computer has SQL Server software installed, go to Verifying your computer has a supported version of SQL Server software installed to verify that you have a version the software supports.