Fortinet black logo

EMS Administration Guide

Customizing the SQL Server Express install directory

Customizing the SQL Server Express install directory

By default, FortiClient EMS is installed with SQL Server Express. Using the CLI to install FortiClient EMS allows you to customize the SQL Server Express install directory.

These instructions do not apply for SQL Server Enterprise or Standard, which must be installed separately from FortiClient EMS. For information on SQL Server Enterprise or Standard and FortiClient EMS, see Installing FortiClient EMS to specify SQL Server Enterprise or Standard instance.

Customizing the SQL Server Express install to a local directory

Use the following command to customize the SQL Server Express install to a local directory:

FortiClientEndpointManagement_6.2.2.XXXX_x64 SQLCmdlineOptions="/INSTANCENAME=FCEMS /INSTANCEDIR=<desired_directory>"

The example below installs FortiClient EMS, installing SQL Server to the C:\sqlserver directory:

FortiClientEndpointManagement_6.2.2.XXXX_x64 SQLCmdlineOptions="/INSTANCENAME=FCEMS /INSTANCEDIR=c:\sqlserver"

Customizing the SQL Server Express install to a remote directory

Use the following command to customize the SQL Server Express install to a remote directory:

FortiClientEndpointManagement_6.2.2.XXXX_x64 InstallFolder=<desired_directory> SQLServer=<SQL_Server_name> SQLServerInstance= SQLService=MSSQLSERVER

The example below installs FortiClient EMS, installing SQL Server to the C:\sqlserver directory on a computer with DNS name WIN-088:

FortiClientEndpointManagement_6.2.2.XXXX_x64 InstallFolder=c:/sqlserver SQLServer=WIN-0888 SQLServerInstance= SQLService=MSSQLSERVER

Customizing the SQL Server Express install directory

By default, FortiClient EMS is installed with SQL Server Express. Using the CLI to install FortiClient EMS allows you to customize the SQL Server Express install directory.

These instructions do not apply for SQL Server Enterprise or Standard, which must be installed separately from FortiClient EMS. For information on SQL Server Enterprise or Standard and FortiClient EMS, see Installing FortiClient EMS to specify SQL Server Enterprise or Standard instance.

Customizing the SQL Server Express install to a local directory

Use the following command to customize the SQL Server Express install to a local directory:

FortiClientEndpointManagement_6.2.2.XXXX_x64 SQLCmdlineOptions="/INSTANCENAME=FCEMS /INSTANCEDIR=<desired_directory>"

The example below installs FortiClient EMS, installing SQL Server to the C:\sqlserver directory:

FortiClientEndpointManagement_6.2.2.XXXX_x64 SQLCmdlineOptions="/INSTANCENAME=FCEMS /INSTANCEDIR=c:\sqlserver"

Customizing the SQL Server Express install to a remote directory

Use the following command to customize the SQL Server Express install to a remote directory:

FortiClientEndpointManagement_6.2.2.XXXX_x64 InstallFolder=<desired_directory> SQLServer=<SQL_Server_name> SQLServerInstance= SQLService=MSSQLSERVER

The example below installs FortiClient EMS, installing SQL Server to the C:\sqlserver directory on a computer with DNS name WIN-088:

FortiClientEndpointManagement_6.2.2.XXXX_x64 InstallFolder=c:/sqlserver SQLServer=WIN-0888 SQLServerInstance= SQLService=MSSQLSERVER