SQL Server Software - Metasys - LIT-12012067 - Configuration software - System Configuration Tool - 13.2

SCT Installation and Upgrade Instructions

Product name
System Configuration Tool
Document type
Installation Guide
Document number
LIT-12012067
Version
13.2
Revision date
2019-10-14

SQL Server must be installed on the same computer as SCT. The following Microsoft SQL Server software versions are supported for use with SCT:

  • SQL Server 2017 Standard, Enterprise, and Express (64-bit)
  • SQL Server 2016 Standard, Enterprise, and Express SP2 (64-bit)
  • SQL Server 2014 Standard, Enterprise, and Express SP3 (64-bit)
  • SQL Server 2012 Standard, Enterprise, and Express SP4 (64-bit)

Before you install or upgrade your SQL Server software, note the following:

  • Microsoft SQL Server 2008 and SQL Server 2008 R2 are no longer supported. For information about how to upgrade SQL Server, refer to SQL Server Software Installation and Upgrade Guide (LIT-12012240) .

  • If your computer has SQL Server software installed, verify that its version is supported for the current version of SCT Release 13.2 software. Go to Verifying Your Computer Has a Supported Version of SQL Server Software Installed.
  • A tool called the SQL Installer is provided on the licensing portal with the Branch Tools download to help you install or upgrade to any supported version of SQL Server software. If you do not have this tool, refer to the SQL Server Software Installation and Upgrade Instructions (LIT-12012240) for details on how to install or upgrade SQL Server software. Also refer to SQL Server Software Installation and Upgrade Instructions (LIT-12012240) this document if you need to apply a new service pack (SP) to an existing installation of SQL Server software because the SQL Installer does not support service pack installations.
  • To use the SQL Installer to install a full version of SQL Server software (for example, SQL Server 2014 Standard edition), you need the Microsoft SQL Server media. To use SQL Installer to install an Express version of SQL Server software (for example, SQL Server 2014 Express), download the SQL Server Express installation file from the Microsoft SQL Server Express website.
  • The SQL Installer verifies that your computer has the prerequisites you need to install SQL Server, including Microsoft .NET Framework version 3.5.1. An error message appears if a prerequisite is not present. You need to install any missing software prerequisites before continuing.

  • The SQL Installer provides an advanced mode that lets you edit the SQL Server command line options before you start the installation. You can also copy the options, paste them into a command window, and run the installation at a command prompt. However, use this method only if you are an advanced user who fully understands SQL Server software options.
  • If you are installing SQL Server software manually, we recommend that you do not enable the C2 audit tracing feature. With C2 audit tracing enabled, SQL Server creates a large number of operational log files that might eventually fill the hard disk and crash the server. However, if you install MVE, the MVE installer enables the C2 audit tracing feature for you. If you want to conserve hard disk space, be sure to disable C2 audit tracing after installing MVE.
  • 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).
  • If you select a SQL Server installation package that includes Management Tools, the SQL Installer adds the SQL Server Management Studio tool for you. No separate installation is necessary. If you select a version of SQL Server Express software that does not include Management Tools, the SQL Installer does not add the SQL Server Management Studio tool for you. For details on how to install SQL Server Management Studio after you install SQL Server software, refer to the SQL Server Software Installation and Upgrade Instructions (LIT-12012240).
  • If you are installing Metasys server software on a server class machine, SQL Server software must be installed and running before you install SCT software.

  • If after you upgrade to a newer version of SQL Server software, you need to open the Metasys archive database in an older version of SQL Server software, use the Export Database option in SCT. Then import the archive that uses an older version of SQL Server software into SCT.

Figure 1 shows the SQL Installer tool. Table 1 describes the fields and selections.

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 (setup.exe or <SQL Server Install>.exe) in this field.

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 for a stand-alone SCT computer. 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

Select whether the local Administrators group or the local Windows Administrator user is granted administrator rights to SQL Server databases.

9

Application Installation Path

Leave this field blank.

10

Default Database Storage Path

Leave this field blank.

11

Command Line Options

Contains the full command-line options that reflect the dialog box selections you made. Only edit the contents of this box if you fully understand SQL Server software options.

12

Find SQL Install Program

Click to open a browser window from which you can select the location of the SQL Server installation or upgrade file. Select the appropriate SQL Server setup (setup.exe) or executable file.

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.

14

Split ADX App Server

Split ADX Data Server

Make no selection; these selections only apply to a split ADX.

15

Install New Instance or Upgrade Existing Instance

Click Install New Instance to start the SQL Server software installation or Upgrade Existing Instance to start the SQL Server software upgrade.

If your computer has SQL Server software installed, go to Verifying Your Computer Has a Supported Version of SQL Server Software Installed to verify that you have a version the Metasys software supports.

The following table lists the default SQL Server installation options that can be used by the Installer.

Table 2. SQL Server Configuration Selections
SQL Server Configuration Screen

SQL Server Express Edition Selections

SQL Server Standard or Enterprise Edition Selections

Setup Role

N/A

SQL Server Feature Installation

Feature Selection

Database Engine Services

Management Tools - Basic (if available)

Unified ADX/ODS or SCT SCT:

Database Engine Services

Reporting Services

Management Tools - Basic

Management Tools - Complete

Web/application server on split ADX:

Reporting Services

Management Tools - Basic

Management Tools - Complete

Instance Configuration

Default Instance

(Named instance is valid as well)

Default Instance

(Named instance is valid as well)

Server Configuration

SQL Server Database Engine:

NT Service\SQLSERVERAGENT1 or NT AUTHORITY\SYSTEM2

SQL Server Browser:

NT AUTHORITY\LOCAL SERVICE

SQL Server Agent:

NT Service\SQLSERVERAGENT1 or NT AUTHORITY\SYSTEM2

SQL Server Database Engine:

NT Service\SQLSERVERAGENT1 or NT AUTHORITY\SYSTEM2

SQL Server Reporting Services:

NT Service\SQLSERVERAGENT1 or NT AUTHORITY\SYSTEM2

SQL Server Browser:

NT AUTHORITY\LOCAL SERVICE

Database Engine Configuration

Mixed Mode

Specify SQL Server Administrators:

BUILTIN\ADMINISTRATORS (Administrators)

Mixed Mode

Specify SQL Server Administrators:

BUILTIN\ADMINISTRATORS (Administrators)

Reporting Services Configuration

N/A

Unified ADX/ODS or SCT:

Reporting Services Native Mode: Install and configure

SQL Server Configuration Manager

Protocols for <instance name>

Named Pipes: Enabled

TCP/IP: Enabled

Named Pipes: Enabled

TCP/IP: Enabled

1 Selection for newer versions of SQL Server software.
2 Selection for older versions of SQL Server software.