Installing or upgrading SQL Server software using the SQL Install Helper - 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

As part of the SQL Server installation and upgrade process, SQL Server Setup checks the configuration of your computer and indicates any potential installation problems. For example, if you do not have the required version of Microsoft .NET Framework installed, SQL Server Setup reports an error. Also, if you try to upgrade an old version of SQL Server software that is not at the minimum service pack level, SQL Server Setup reports an error and cannot continue until you apply the required service pack update. You must resolve all issues before you continue with SQL Server software installation.

If you are installing SQL Server software without any previous versions of SQL Server software, go straight to Step 2.

Procedure

  1. If you are upgrading to a newer edition of SQL Server software, uninstall all Metasys software before you perform the upgrade. Also, make sure you retain all scheduled actions and keep all Metasys databases. After all Metasys software is uninstalled, go to the next step.
  2. Obtain the SQL Server Software installation file.
    Note: Use the links provided in the SQL Server overview for the Express Versions.
  3. Using Windows Explorer or File Explorer, locate the SQL Server Software Installer folder.
  4. Double-click the SQLInstallHelper.exe file. The SQL Installer dialog box appears.
    Note: If you install SQL Server 2016, SQL Management Studio is not installed with the SQL Server software. Click Download Management Studio Install Program. Your default web browser opens this Microsoft website. You must manually install SQL Server Management Studio. See Installing SQL Server Management Studio (SSMS). You can choose to install this software now or do so after installing SQL Server using the SQL Install Helper.
  5. In the SQL Install Helper, click Find SQL Install Program. The Open dialog box appears.
  6. Browse to the location of the installation or upgrade file for a supported version of SQL Server software.
  7. Select the installation or upgrade file and click Open. The Microsoft Software License Terms window appears.
    Note: The SQL Installer tool is not compatible with SSEI files, such as the SQLServer201x-SSEI.exe. If you obtained an SSEI file, you must run it separately. Choose Download Media, then Express. This downloads the setup file which may be used with the SQL Installer tool, such as the SQLEXPR_x64_ENU.exe.
  8. Click Accept. The Microsoft Software License Terms window closes and the I accept the Microsoft software Terms and conditions selection of the SQL Installer window is checked.

    If you are installing or upgrading SQL Server software for a split ADX, skip straight to Step 9.

    If you are installing or upgrading SQL Server software for a unified ADX and SCT, follow these steps:

    1. Type a complex password for the SQL Server administrator (SA) user account in the SA password field.
    2. (Optional) To specify a database default instance, click Show Advanced Options and specify an instance name in the Instance Name field. If not specified, the SQL installer uses the default instance name.
    3. Click Install New Instance (for installations) or Upgrade Existing Instance (for upgrades).
      Note: To switch between Upgrade and Install, you can tab out of the Instance Name field or left-click on the Command Line Options area.
    4. Go to Step 9.
  9. To install or upgrade SQL Server software for a split ADX:
    1. Select the split computer type: Split ADX App Server or Split ADX Data Server.
    2. Type a complex SA password.
    3. If you want to change any SQL Server installation defaults, such as the location where the software installs or the database instance name, click Show Advanced Options.
    4. Specify an instance name. You must use MSSQLSERVER if you plan to install Reporting Services on the web/application server computer in a split ADX configuration.
    5. If you are installing the web/application server, optionally specify the full pathname where you want to install SQL Server software. Leave this field blank to accept the default location.
    6. If you are installing the database server, optionally specify the full pathname where you want to install SQL Server software. Leave this field blank to accept the default location.
    7. Click Install New Instance (for installs) or Upgrade Existing Instance (for upgrades).

    SQL Server software installation occurs in the background. Installation can take over 15 minutes to complete. No SQL Server Setup screens appear. When the process is finished, the message box Install Succeeded appears.

    Note: You may be prompted to provide a location for temporary installation files, particularly if you are installing SQL Server Express.
  10. Click OK.
  11. Restart the computer only if the SQL Installer prompts you to do so.

    For a split ADX only, repeat the steps in this section to install the required SQL Server software components on the second server of the split system. Then, go to Specific system requirements for the Metasys Advanced Reporting System to configure Reporting Services on the web/application server of the split ADX.

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