Installing SQL Server 2016 SP2 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

About this task

Procedure

  1. To install SQL Server 2016 SP2 Express software, click this link and download the file.
  2. To extract the files to a temporary location on your hard disk and begin the update, double-click the SQL Server installation files that you downloaded. If a User Account Control dialog box appears, click Yes.
  3. 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.
  4. The Select an installation type window appears. Select Custom.
  5. The Specify SQL Server media download target location window appears. Select a location for the media to download or keep the default location. Click Install. The Downloading install package windows appears. After the download completes, the window closes and the Please wait while Microsoft SQL Server 2016 Setup processes the current operation appears.
  6. The Planning menu is the first screen to appear. In the right pane, several options are available. To begin, select Installation in the left pane.
  7. Click New SQL Server stand-alone installation or add features to an existing installation.
  8. Read the License Terms agreement and then select the I accept the license terms check box. Click Next.
  9. A report appears that lists the results of a final Install Rules test.
    Note: Your screen may look slightly different from this example. 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.
  11. Select the Database Engine Services check box. Click Next.
  12. Click Named instance and type MSSQLSERVER in the Named instance field. The Instance ID field fills in for you. MSSQLSERVER is the instance you are going to use with Metasys software. Click Next.
  13. 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. Click Next.
  14. 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.
    Notes:
    • 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.
  15. In the Database Engine Configuration screen, under the Specify SQL Server administrators section:
    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.
  16. SQL Server 2016 Express 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.
  17. Installation is complete. Close all SQL Server installation windows. This version of SQL Server does not install any Management Tools. You must manually install SQL Server Management Studio. After you complete this procedure, see Installing SQL Server Management Studio (SSMS).
  18. 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.
  19. 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.