Installing SQL Server 2019 or SQL Server 2019 Express software - 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

Before you begin

The SQL Installer Tool supports SQL Server 2019. These releases do not integrate SQL Server Reporting Services in their install process. You must run the SQL Server Reporting Services program separately.
Note: SQL Server 2019 can cause the configuration service cache that builds stored procedures to time out. This causes the user's login to Metasys UI to fail. To resolve this issue, set SQL Server 2019 databases to run in 2017 compatibility mode. For more information, refer to docs.microsoft.com.

Procedure

  1. Run the SQL Server 2019 software setup.exe file.
    Note: If you do not have a required prerequisite, a box appears and indicates what is missing. Click OK, install the missing prerequisite, and then restart the procedure.
  2. In the SQL Server Installation Center window, click Installation. For SQL Server 2019 Express, select Custom.
    Figure 1. Installation type
  3. In the right pane, click New SQL Server stand-alone installation or add features to an existing installation.
  4. If required, in the Product Key window, enter the product key.
  5. Read the license terms agreement, and select the I accept the license terms check box.
  6. In the Install Rules window, a report indicates the status of prerequisite components. If any prerequisite fails, exit the installation and fix the issue before you continue. For more information, click the Failed cell. You can ignore any warnings at this stage. Click Next.
  7. In the Feature Selection window, select the appropriate check boxes. Under the Database Engine Services feature, ensure you select Database Engine Services feature as Metasys products require it. However, clear the Machine Learning Services options and Full-Text and Semantic Extraction options. Metasys products do not require these options.
    Figure 2. Feature selection
    Note: There are more instance features and shared features available on SQL Server 2019 Standard than SQL Server 2019 Express. Select the features that best suit your requirements, but you must select the Database Engine Services for Metasys.
    • To install SQL Server 2019 for a SCT computer, a unified ADX/OAS/NAE85/LCS85 computer, or a split ADX data server computer, select the Database Engine Services check box.
  8. In the Instance Configuration window, click Default instance (preferred), or click Named instance, and type the name of the instance you use with the Metasys software. Click Next.
    Figure 3. Instance configuration
  9. In the Server Configuration window, complete the following steps:
    1. Accept the default Account Name setting for all services shown.
    2. In the Collation tab, verify that the following engine SQL_Latin1_General_CP1_CI_AS is in the Database Engine field.
    Figure 4. Server configuration
  10. In the Database Engine Configuration window, complete the following steps:
    1. Click Mixed Mode (SQL Server authentication and Windows authentication).
      Figure 5. Database engine configuration
    2. In the password fields, type a strong password for the SQL Server administrator (SA) user account. To comply with Microsoft password guidelines, see SQL Server overview. Safeguard this user name and password. Without these credentials, you cannot maintain the database.
    3. To permit the Metasys software to create SQL Server users using Windows authentication, you must specify the BUILTIN\Administrators account as a SQL Server administrator. In the Specify SQL Server administrators area, click Add.
    4. In the Select users or Groups dialog box, click Advanced. A second Select users or Groups dialog box appears, click Find Now.
      Figure 6. Select users, computers, service accounts or groups



      1. If the computer is not a member of a domain, in the Search results, select Administrators.
      2. If the computer is a member of a domain, click Locations and select the location from the domain. Type Administrators in the Enter the object name to select box.
      3. Click Check Names. The entry <Your computer name>\Administrators appears in the box. Make sure that the entry contains Administrators (plural), and not Administrator (singular). The entry BUILTIN\Administrators appears in the Specify SQL Server Administrators area.
    Note: If the customer's IT department is involved with the SQL Server software installation and does not permit the use of the BUILTIN\Administrators user, request that the IT department select a different SQL Server administrator user. Click OK, click Next.
  11. SQL Server 2019 Standard only: In the Ready to Install window, read the summary report to ensure that the configuration contains everything you need before you click Install. If you have missed any components, click Back.
  12. In the Installation Progress window, you see the installation progress bar. This part of the procedure can take over 15 minutes to complete. When the Complete window appears, you see a status update for each component you installed, and an install successful message. Click Close.
  13. To enable communication protocols for the databases, start SQL Server Configuration Manager.
  14. Expand Sql Server Network Configuration, and select Protocols for MSSQLSERVER.
  15. In the right pane, complete the following steps:
    1. Right-click Named Pipes and select Enable. Click OK to the warning message.
    2. Right-click TCP/IP and select Enable. Click OK to the warning message.
  16. Close the Sql Server Configuration Manager.
  17. Install SQL Server Management Studio after you complete this procedure. For more information, see Installing SQL Server Management Studio (SSMS).
    Figure 7. SQL server configuration manager