To help you install or upgrade to any supported version of SQL Server software, we provide a tool on the License Portal called SQL Installer under Branch Tools > SQL Server Software Installer, 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 2017. For more information, see Installing SQL Server Reporting Services for SQL Server 2017.
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/OAS/NAE85/LCS85, 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.
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.
|
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. 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, OAS, NAE85, LCS85, 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. Ensure that the password meets any rules that apply to the machine. |
|
5 |
Software Key |
Enter the software license key required to activate SQL Server software. 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
|
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 web/application server. Enter as a full path starting with the drive letter. Leave this field blank for a unified ADX, ADS-Lite, 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, 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 |
|
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. Some 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, or SCT computer. Follow the on-screen instructions to download SQL Server Reporting Services. |
|
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. |