Fortinet black logo

EMS Administration Guide

Customizing the SQL Server Express install directory

Customizing the SQL Server Express install directory

By default, the FortiClient EMS installation also installs 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 you must install 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.4.2.XXXX_x64 SQLCmdlineOptions="/INSTANCENAME=FCEMS /INSTANCEDIR=<desired_directory>"

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

FortiClientEndpointManagement_6.4.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.4.2.XXXX_x64 InstallFolder=<desired_directory> SQLServer=<SQL_Server_name> SQLServerInstance= SQLService=MSSQLSERVER

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

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

Customizing the SQL Server Express install directory

By default, the FortiClient EMS installation also installs 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 you must install 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.4.2.XXXX_x64 SQLCmdlineOptions="/INSTANCENAME=FCEMS /INSTANCEDIR=<desired_directory>"

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

FortiClientEndpointManagement_6.4.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.4.2.XXXX_x64 InstallFolder=<desired_directory> SQLServer=<SQL_Server_name> SQLServerInstance= SQLService=MSSQLSERVER

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

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