SQL Server overview - Metasys - LIT-12012240 - Server - SQL Server - 13.0.50

SQL Server Installation and Upgrade Guide
Product name
SQL Server
Document type
Installation Guide
Document number
LIT-12012240
Version
13.0.50
Revision date
2024-04-09
Product status
Active

Metasys software can use the following editions of Microsoft SQL Server software:

Express Versions

  • SQL Server® 2022 Express with CU9 (64-bit) link
  • SQL Server® 2019 Express with CU18 (64-bit) link
  • SQL Server® 2017 Express with CU31 (64-bit) link

Full Versions

  • SQL Server® 2022 with CU9 (64-bit) Standard or Enterprise
  • SQL Server® 2019 with CU18 (64-bit) Standard or Enterprise
  • SQL Server® 2017 with CU31 (64-bit) Standard or Enterprise
Note: SQL Server 2019 and SQL Server 2022 do not support the Metasys Advanced Reporting System (ARS).

If your computer already has a version of SQL Server software installed that does not match any of these versions, use this document and the Microsoft SQL Server proprietary documentation to help you upgrade the software to a supported version. To verify the edition, see Verifying your computer has a supported version of SQL Server software installed. To download the SQL Installer tool using the License Portal, see SQL Installer tool for more information.

Make sure that you match the version of SQL Server software with the supported version of your Microsoft Windows® operating system. If you want to upgrade to a 64-bit version of SQL Server from a 32-bit version of SQL Server, you need to replace the 32-bit operating system with a 64-bit version. This is known as an out-of-place upgrade.

Before installing any edition of SQL Server software, make sure you have installed Microsoft .NET Framework version 3.5.1 and Microsoft .NET Framework 4.7.2 and Microsoft .NET 6.0.16. This prerequisite is checked as part of the SQL Server software installation process.

If you must purchase a full edition of SQL software, you need the Microsoft SQL Server software installation media. For the Express editions of SQL Server software that are free, you can access the installation files from the Microsoft SQL Server download website. Direct links are provided in this document.

For the SQL Server Express software editions that we support, the installation may also include a background installation of SQL Server Compact 4.0 software. This software is not known to interfere with the Metasys system, so do not manually uninstall SQL Server Compact 4.0 software.

As part of the installation, the SQL Server Setup performs a system configuration check on your computer and indicates any potential installation problems. You must resolve all issues before continuing with the SQL Server software installation.

If you upgrade to a newer edition of SQL Server Express software, the same settings from the older version of SQL Server software are used, including the reuse of the existing SQL Server administrator (SA) and password, and the selection of Mixed Mode authentication. You cannot change these settings during the upgrade. In addition, the upgrade process prompts you to select the database instance you want to upgrade. Be sure to select the instance that is currently in use by the Metasys software.

After you install SQL Server software successfully, add the Microsoft SQL Server Management Studio. You can obtain SQL Server Management Studio from the Microsoft SQL Server download website. For details, see Appendix: Installing SQL Server Management Studio.

For some SQL Server software installation settings, you may need to consult the customer’s IT department to ensure compliance with its processes. In the absence of your IT department's input, use the settings indicated in this document. However, during the SQL Server installation, you must select Mixed Mode authentication and select BUILTIN\Administrators as a SQL Server administrator. When you specify SQL Server Authentication for the installation, enter a strong system SA password for the Microsoft SQL Server software. Create a Microsoft Corporation password that complies with the following guidelines: contains a combination of eight or more letters, numbers, and symbols.
Note: Metasys does not support the use of the symbols &, <, >, and / as part of the SQL SA user password when used with SQL Authentication.

Your password should be difficult to guess; for example, does not exist in a dictionary, does not match the name of the user or a person. In addition it is best practice to change the password often; for example, every 90 days. For more information, see http://www.microsoft.com, or consult with the IT department if you have questions about SA passwords.