Installing SQL Server 2019 or SQL Server 2019 Express software - Metasys - LIT-12012240 - Server - SQL Server - 11.0

SQL Server Installation and Upgrade Guide
Brand
Metasys
Product name
SQL Server
Document type
Installation Guide
Document number
LIT-12012240
Version
11.0
Revision date
2021-02-05
Product status
Active
Language
English

Before you begin

The SQL Installer Tool does not support SQL Server 2019 or SQL Server 2017. These releases do not integrate SQL Server Reporting Services in their install process. You must run the SQL Server Reporting Services program separately.

Metasys Advanced Reporting System and Energy Essentials does not support SQL Server 2019.

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.
  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.
    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/ODS 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.
  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.
  10. In the Database Engine Configuration window, complete the following steps:
    1. Click Mixed Mode (SQL Server authentication and Windows authentication).
    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.
      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.
    Note: You must run the SQL Server Reporting Services installation program separately. For more information, see SQL Server Reporting Services.

    SQL Server 2019 does not install any management tools. You must manually install SQL Server Management Studio after you complete this procedure. For more information, see Installing SQL Server Management Studio (SSMS).