Installing SQL Server 2017 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
  1. Run the SQL Server 2017 software installation 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 start over with this procedure.
  2. The Planning menu appears. In the right pane, several options are available. To begin, select Installation in the left pane.
  3. Click New SQL Server stand-alone installation or add features to an existing installation. The Product Key window appears.
  4. If required, enter the product key.
  5. Click Next.
  6. Read the License Terms agreement and then select the I accept the license terms check box.
  7. Click Next.
  8. Click Install to install the necessary product update files and setup support files. During this step, access to the Internet is required as SQL Server Setup must be online for installation updates.
  9. Click Next to continue. A report appears that lists the results of a final Install Rules test. If any prerequisite fails, you need to exit the installation and fix that issue. For more information, click the Failed cell. Any Warning report can be ignored at this point.
  10. Click Next. The Feature Selection screen appears.
    Note: Some components may not be visible on the Feature Selection screen, depending on your configuration.

    To install SQL Server 2017 for a SCT computer, a unified ADX/ODS computer, or a split ADX/ODS computer, select the Database Engine Services check box.

    Note: This version of SQL Server 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). To install Metasys Advanced Reporting System, complete this procedure and then see SQL Server Reporting Services.
  11. Click Next.
  12. Click Default instance (preferred) or click Named instance and type the name of the instance you are using with Metasys software.
    Note: You must use MSSQLSERVER if you plan to install Reporting Services on the web/application server in a split ADX configuration
  13. Click Next.
  14. Accept the default Account Name setting for all services shown on the Server Configuration screen. Verify the Collation tab lists SQL_Latin1_General_CP1_CI_AS. Metasys software requires this SQL Collation
  15. Click Next.
  16. Click Mixed Mode (SQL Server authentication and Windows authentication). Specify a strong password for the SQL Server administrator (SA) user account and specify the BUILTIN \Administrators account.
    Note: This screen does not appear on the web/application server of a split ADX with the Metasys Advanced Reporting System.

    Microsoft Corporation recommends a complex password that contains eight or more letters, numbers, and symbols that cannot be guessed easily. Visit http://www.microsoft.com or consult with the IT department if you question about SA passwords.

    Safeguard this user name and password. Without these credentials, you cannot maintain the database.
    Important: You must specify the BUILTIN\Administrators account as a SQL Server administrator to permit the Metasys software to create SQL Server users through Windows authentication. You add this account in the next step.
  17. In the Database Engine Configuration screen, under the Specify SQL Server administrators:
    1. Click Add. The Select Users or Groups dialog box appears.
    2. Click Advanced. A second Select Users or Groups dialog box appears.
    3. Click Find Now. If the computer is not a member of a domain, select Administrators in the Search results and click OK. 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.
    4. Click Check Names. The entry <Your Computer Name>\Administrators appears in the box. Make sure the entry contains Administrators (plural), and not Administrator (singular).
    5. Click OK to close the box. The entry BUILTIN\Administrators appears in the Specify SQL Server administrators section.
      Note: If the customer's IT department is involved with 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.
    6. Click Next.
      Note: Metasys Advanced Reporting Services ONLY: If this screen does not appear (for example, on the database computer of a split ADX with Metasys Advanced Reporting System), go to the next step.
  18. Click Install and configure if you are installing a unified ADX. Click Install only if you are installing Reporting Services on the web/application server of a split ADX.
  19. Click Next.
  20. An Installation Rules test runs. Verify that no tests fail. If a test failed, you need to exit the installation and correct the issue before continuing.
  21. Click the Failed cell for more information.
  22. Click Next. A summary screen appears with a list of your selections. Verify the list.
  23. Click Install to begin.
  24. SQL Server 2017 software installs as indicated by the Installation Progress screen. This part of the procedure can take over 15 minutes to complete. Wait until Succeeded appears in the Status column of each component.
  25. When the installation is complete. Close all SQL Server installation windows.
  26. Start SQL Server Configuration Manager. Expand SQL Server Network Configuration and select Protocols for MSSQLSERVER.
    Note: If you have a different named instance, that name appears instead of MSSQLSERVER.
  27. In the right pane of the window, do the following:
    1. Right-click Named Pipes and select Enable.
    2. Click OK to the SQL Server software restart warning message that appears.
    3. Right-click TCP/IP and select Enable.
    4. Click OK to the warning message.
    5. Close the SQL Server Configuration Manager
Note: If you plan to install the Metasys Advanced Reporting System, first see SQL Server Reporting Services.