Fortinet black logo

Version:

7.2.1
7.2.0
7.0.9

Version:

7.0.8
7.0.7
7.0.6

Version:

7.0.4
7.0.3
7.0.2

Version:

7.0.1
7.0.0
6.4.9

Version:

6.4.8
6.4.7
6.4.4

Version:

6.4.3
6.4.2
6.4.1

Version:

6.4.0
6.2.9
6.2.8

Version:

6.2.7
6.2.6
6.2.4

Version:

6.2.3
6.2.2
6.2.1

Version:

6.2.0
6.0.8
6.0.6

Version:

6.0.5
6.0.4
6.0.3

Version:

6.0.2
6.0.1
6.0.0

Table of Contents

EMS Administration Guide

6.0.3
7.2.1
7.2.0
7.0.9
7.0.8
7.0.7
7.0.6
7.0.4
7.0.3
7.0.2
7.0.1
7.0.0
6.4.9
6.4.8
6.4.7
6.4.4
6.4.3
6.4.2
6.4.1
6.4.0
6.2.9
6.2.8
6.2.7
6.2.6
6.2.4
6.2.3
6.2.2
6.2.1
6.2.0
6.0.8
6.0.6
6.0.5
6.0.4
6.0.3
6.0.2
6.0.1
6.0.0
Download PDF
Copy Doc ID 22af35b8-ccd3-11e8-8784-00505692583a:643251
Copy Link

Local existing database

This section lists the CLI commands for when FortiClient EMS and SQL Server Enterprise or Standard are installed on the same machine.

Database type

Command

Local default instance using SQL authentication

FortiClientEnterpriseManagement_6.0.3.XXXX_x64.exe SQLUser=<username> SQLUserPassword=<password> InstallSQL=0 ScriptDB=1 SQLServerInstance= SQLService=<instance_name> SQLCmdlineOptions="/INSTANCENAME="

Local default instance using local Windows authentication

FortiClientEnterpriseManagement_6.0.3.XXXX_x64.exe SQLServerInstance= SQLService=<instance_name> SQLCmdlineOptions="/INSTANCENAME=" InstallSQL=0 ScriptDB=1

Local named instance using SQL authentication

FortiClientEnterpriseManagement_6.0.3.XXXX_x64.exe SQLUser=<username> SQLUserPassword=<password> InstallSQL=0 ScriptDB=1 SQLServerInstance=<instance_name> SQLService=mssql$<instance_name> SQLCmdlineOptions="/INSTANCENAME=<instance_name>"

Local named instance using local Windows authentication

FortiClientEnterpriseManagement_6.0.3.XXXX_x64.exe SQLServerInstance=<instance_name> SQLService=mssql$<instance_name> SQLCmdlineOptions="/INSTANCENAME=<instance_name>" InstallSQL=0 ScriptDB=1

For example, if installing FortiClient EMS and pointing to a local instance named "database000" using SQL authentication, with SQL username "janedoe", password "password123", the command would be as follows:

FortiClientEnterpriseManagement_6.0.3.XXXX_x64.exe SQLUser=janedoe SQLUserPassword=password123 InstallSQL=0 ScriptDB=1 SQLServerInstance=database000 SQLService=mssql$database000 SQLCmdlineOptions="/INSTANCENAME=database000"

Previous
Next

Local existing database

This section lists the CLI commands for when FortiClient EMS and SQL Server Enterprise or Standard are installed on the same machine.

Database type

Command

Local default instance using SQL authentication

FortiClientEnterpriseManagement_6.0.3.XXXX_x64.exe SQLUser=<username> SQLUserPassword=<password> InstallSQL=0 ScriptDB=1 SQLServerInstance= SQLService=<instance_name> SQLCmdlineOptions="/INSTANCENAME="

Local default instance using local Windows authentication

FortiClientEnterpriseManagement_6.0.3.XXXX_x64.exe SQLServerInstance= SQLService=<instance_name> SQLCmdlineOptions="/INSTANCENAME=" InstallSQL=0 ScriptDB=1

Local named instance using SQL authentication

FortiClientEnterpriseManagement_6.0.3.XXXX_x64.exe SQLUser=<username> SQLUserPassword=<password> InstallSQL=0 ScriptDB=1 SQLServerInstance=<instance_name> SQLService=mssql$<instance_name> SQLCmdlineOptions="/INSTANCENAME=<instance_name>"

Local named instance using local Windows authentication

FortiClientEnterpriseManagement_6.0.3.XXXX_x64.exe SQLServerInstance=<instance_name> SQLService=mssql$<instance_name> SQLCmdlineOptions="/INSTANCENAME=<instance_name>" InstallSQL=0 ScriptDB=1

For example, if installing FortiClient EMS and pointing to a local instance named "database000" using SQL authentication, with SQL username "janedoe", password "password123", the command would be as follows:

FortiClientEnterpriseManagement_6.0.3.XXXX_x64.exe SQLUser=janedoe SQLUserPassword=password123 InstallSQL=0 ScriptDB=1 SQLServerInstance=database000 SQLService=mssql$database000 SQLCmdlineOptions="/INSTANCENAME=database000"

Previous
Next