SQL Installer tool - Metasys - LIT-12012240 - Server - SQL Server

To help you install or upgrade to any supported version of SQL Server software, we provide a tool called SQL Installer on the License Portal, see Figure 1. However, you cannot use the SQL Installer to apply a new Service Pack (SP) to an existing installation of SQL Server software. To apply a SP, refer to the appropriate upgrade section in this document. You also, cannot use the SQL Installer tool to install the SQL Server Reporting Services 2019 or 2017 installation program. For more information, see Installing SQL Server Reporting Services for SQL Server 2019 and SQL Server 2017

To use the SQL Installer to install a full version of SQL Server software (for example, SQL Server 2019 Standard edition), you need Microsoft SQL Server media. To use SQL Installer to install an express version of SQL Server software (for example, SQL Server 2019 Express), download the installation file from the Microsoft SQL Server Express website. We provide direct links in the SQL Server installation sections of this document.

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.

The SQL Installer supports both unified ADS/ADX/ODS/OAS and split ADX installations, with or without the Metasys Advanced Reporting Services. If you have a split ADX with Metasys Advanced Reporting Services, first run the SQL Installer to put down the Database Engine Services component on the database server. Then, run the SQL Installer to put down the Reporting Services component on the web/application server. You may also use the SQL Installer to install SQL Server software on an SCT computer.

Note: The order of installation is not a strict requirement. Remember to configure the SQL Server Reporting Services (SSRS) component after installing each SQL instance and component. See Configuring SQL Server Reporting Services.

The SQL Installer verifies that your computer has the prerequisites you need to install SQL Server, including Microsoft .NET Framework version 3.5 and Microsoft .NET Framework 4.7.2, and Windows Installer 5.0. An error message appears if a prerequisite is not present. Before you can continue, you need to install any missing software prerequisites.

Use the advanced mode in the SQL Installer to view the SQL Server command line options before you start the installation. You cannot edit this area of the screen to change the options. However, you can copy and paste them into a command window, edit the options, then run the installation at a command prompt. Use this method only if you are an advanced user who fully understands SQL Server software options.

As part of the installation, the SQL Installer may require you to select an instance name. If you are installing a unified ADS/ADX/ODS/OAS, a stand-alone SCT computer, or the database server of a split ADX, use the default instance name. If you are installing the web/application server of a split ADX, you must use the default instance name of MSSQLSERVER. The ADX installation and rename processes require the default instance name of MSSQLSERVER on the web/application server in order to ensure that SQL Server's Reporting Services feature runs correctly.

Important: The latest available version of the ODS is Release 10.1. The ODS is not available for upgrade to Metasys Release 11.0.

The SA password that you specify in the SQL Installer window must follow the rules for Microsoft complex passwords. For more information about complex passwords, refer to the Security Administrator System Technical Bulletin (LIT-1201528).

Figure 1 shows the SQL Installer tool and Table 1 describes its fields and selections. For instructions on how to use the SQL Installer to install a unified or split Metasys server, see Installing or upgrading SQL Server software using the SQL Install Helper.

Figure 1. SQL Installer Window

Table 1. Description of SQL Installer Window
Callout	Attribute	Action
1	<File Name Location>	Click Find SQL Install Program to enter the location of the SQL Server software installation or upgrade file. Note: If you are installing a full version of SQL Server, this file must be the setup.exe file located on the SQL Server media. If you install an Express version of SQL Server, this file must be the .exe file that you downloaded from the Microsoft Software Download Center website (for example, SQLEXPR_x64_ENU.exe).
2	<License Check Box>	Select the I accept the Microsoft software Terms and conditions check box.
3	Unified ADS/ADX or SCT	Select this option if you install an ADS, ADS-Lite, ODS, SCT, or unified ADX. This selection appears only for a new SQL Server installation.
4	SA Password	Specify a secure SA password for the SQL Server administrator account. This selection appears only for a new SQL Server installation.
5	Software Key	Enter the software license key required to activate SQL Server software, usually found on the media label. This selection appears only for a new SQL Server installation.
6	Show Advanced Options	Select this check box to enable the advanced options editing window.
7	Instance Name	Specify a database instance name for SQL Server.
8	Windows Account Granted SA Access Local Administrators Group Local Windows Administrator	For administrator rights to the SQL Server databases, select if you want the local Administrators group, or the local Windows Administrator user.
9	Application Installation Path	Indicate where you want to install the Reporting Services component of SQL Server, on the unified ADX, or the web/application server of a split ADX. Enter as a full path starting with the drive letter (for example, D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\Reporting Services). Leave this field blank for a unified ADX, ADS-Lite, ODS, or SCT computer if all SQL Server components are installed on the C: drive.
10	Default Database Storage Path	Indicate where you want to install the Database Engine Services component of SQL Server, on the unified ADX, or the database server of a split ADX. Enter as a full path starting with the drive letter (for example, D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER). Leave this field blank for a unified ADX, ADS-Lite, ODS, or SCT computer if all SQL Server components are installed on the C: drive.
11	Command Line Options	Contains the full command-line options that reflect the dialog box selections you made. You cannot edit this area of the screen.
12	Find SQL Install Program	Click to open a browser window where you can select the location of the SQL Server installation or upgrade file. Select the appropriate SQL Server Setup executable file, for example `setup.exe`.
13	Download Management Studio Install Program	Click to access the Microsoft download page to download the latest version of SQL Server Management Studio (SSMS). SSMS is backward-compatible with all earlier versions of SQL Server. SQL Server 2016 and SQL Server 2016 Express do not install SQL Server Management Studio. Other SQL Server versions may not install SQL Server Management Studio. You must manually install SQL Server Management Studio, see Installing SQL Server Management Studio (SSMS). If you install a SQL Server software version that includes Management Tool software, you do not need to click this button.
14	Split ADX App Server Split ADX Data Server	To install SQL Server on the web/application server, select Split ADX App Server. To install SQL Server on the database server, select Split ADX Data Server. These selections appear only for a new SQL Server installation. Do not make this selection for a unified ADX, ADS-Lite, OAS, ODS, or SCT computer.
15	Install New Instance or Upgrade Existing Instance	To start the SQL Server software installation, click Install New Instance. To start the SQL Server software upgrade, click Upgrade Existing Instance. Note: To switch between install and upgrade, you can tab out of the Instance Name field, or left-click the Command Line Options area .

SQL Installer tool - Metasys - LIT-12012240 - Server - SQL Server - 11.0

SQL Server Installation and Upgrade Guide