Installing SQL Server 2014 SP3 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 2014 SP3 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 install, double-click the SQL Server installation files that you downloaded.
  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 Planning menu is the first screen to appear. In the right pane, several options are available for you to explore. To begin, click Installation in the left pane.
  5. Click New SQL Server stand-alone installation or add features to an existing installation.
  6. Read the License Terms agreement and then select the I accept the license terms check box. Click Next.
  7. 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 looks online for installation updates. If the computer does not have access to the Internet and Windows Update service, then you may get an error message. You can ignore the error message and skip the step of obtaining SQL Server updates. Click Next to continue.
  8. A report appears that lists the results of a final Setup Support 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.) Click Next to continue.
  9. Select the Database Engine Services and Management Tools - Basic check boxes. Click Next.
  10. 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.
  11. Accept the default Account Name settings 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.
  12. Click Mixed Mode and define a strong password for the SQL Server administrator (SA) user account. Specify the BUILTIN\Administrators account.

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

    Safeguard this user name and password pair. You cannot maintain the database without it.

    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.
  13. On the Database Engine Configuration window, 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 names 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.
  14. SQL Server 2014 SP3 Express software installs as indicated by the Installation Progress screen. This part of the procedure can take over 15 minutes to complete.
  15. The Complete screen appears. Verify that each component reports a successful installation. Click Close.
  16. Start SQL Server Configuration Manager.
  17. Expand SQL Server Network Configuration and select Protocols for MSSQLSERVER.
    Note: If you have a different named instance, that name appears instead of MSSQLSERVER. 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.