Sage Configured Installation for SQL Server
Note: This article applies to Sage 100 Premium.
The Microsoft SQL Server Runtime Edition installation program purchased through Sage has a Sage Configured Option for installing SQL Server. If you select this option, parameter settings are defined as shown in the following table.
Parameter |
Setting |
Description |
---|---|---|
ACTION |
INSTALL |
Specifies a setup work flow, such as Install, Uninstall, or Upgrade. This is a required parameter. |
FEATURES |
SQL, IS, TOOLS |
Specifies which features to install, uninstall, or upgrade. The list of top-level features includes SQL, AS, RS, IS, and Tools. The SQL feature installs the database engine, replication, and full-text. The IS feature installs Integration Services, which includes the SQL Server Import and Export Wizard, Log Providers and Logging, XML Source, SSIS Run-Time, Basic Data Profiling Tools, and SSIS Package Designer and Service. The Tools feature installs Management Tools, Books Online, Business Intelligence Development Studio, and other shared components. |
INSTANCENAME |
MSSQLSERVER |
Specifies a default or named instance. MSSQLSERVER is the default instance for non-Express editions, and SQL Express is the default for Express editions. This parameter is required when installing the SQL Server Database Engine (SQL), Analysis Services (AS), or Reporting Services (RS). |
SECURITYMODE |
SQL |
SQL is used for mixed-mode authentication. |
SQLSVCACCOUNT |
SYSTEM |
Specifies the account for the SQL Server service: domain\user or system account. |
ISSVCAccount |
SYSTEM |
Can be either domain user name or a system account. |
SQLSYSADMINACCOUNTS |
ADMINISTRATOR |
Specifies which Windows account(s) to provision as SQL Server system administrators. |
AGTSVCACCOUNT |
SYSTEM |
Can be either domain user name or a system account. |