Installing SQL Server 2014 SP3 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. Run the SQL Server 2014 SP3 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 is the first screen to appear. 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.
  4. The Product Key window appears. If required, enter the product key. Click Next.
  5. Read the License Terms agreement and then select the I accept the license terms check box. Click Next.
  6. 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. Click Next to continue.
  7. A report appears that lists the results of a final Install Rules test. 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.) Click Next.
  8. A Setup Role selection screen appears that enables you to select a default installation of SQL Server Feature components. Click SQL Server Feature Installation. Click Next. The Feature Selection screen appears.
    Note: Some components may not be visible on the Feature Selection screen, depending on your configuration. Make the appropriate selections using the following:

    Database Engine Services:

    • Required for the SCT computer
    • Required for the unified ADX/ODS computer
    • Required for the database server of a split ADX
    Reporting Services - Native:
    • Required for the unified ADX/ODS with the Metasys Advanced Reporting System
    • Required for the web/application server of a split ADX with the Metasys Advanced Reporting System
    Note: If you want the Metasys Advanced Reporting System, you must select Reporting Services now. It is not an available choice if you later apply a service pack.

    Management Tools - Basic: Required

    Management Tools - Complete: Required

    Click Next.

  9. Click Default instance (preferred) or click Named instance and type the name of the instance you are using with Metasys software. You must use MSSQLSERVER if you plan to install Reporting Services on the web/application server in a split ADX configuration. Click Next.
  10. 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.
    Note: This screen does not appear on the web/application server of a split ADX with the Metasys Advanced Reporting System.
  11. 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.
    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 have questions 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.
  12. 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.
    Metasys Advanced Reporting Services Only:
    Note: If this screen does not appear (for example, on the database server of a split ADX with the Metasys Advanced Reporting System), go to the next step.
  13. 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. Click Next.
  14. SQL Server Setup runs an Installation Rules test. Verify that no tests fail. If a test failed, you need to exit the installation and correct the issue before continuing. Click the Failed cell for more information. Click Next.
  15. A summary screen appears with a list of your selections. Verify the list. Click Install to begin.
  16. SQL Server 2014 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.
  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.
    Figure 1. SQL Server Configuration Manager

  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.

    If you plan to install the Metasys Advanced Reporting System, go to Installing Microsoft Report Viewer 2012 redistributable package.