Fortinet black logo

EMS Administration Guide

Remote existing database

Remote existing database

Creating a backup directory

Prior to installing FortiClient EMS, create a backup directory on the database server and set the permissions as described below.

  1. On the database server, create a backup directory.
  2. Right-click the directory and select Properties.
  3. On the Security tab, ensure all users have full control of the directory.
Installation commands for remote existing databases

For remote instances using Windows authentication (domain user), do the following:

  1. Join the EMS and database servers to the same domain.
  2. Create a database user that maps to the domain user.
  3. In Local Group Policy Editor, add the domain user to the Log on as a service policy.

Database type

Command

Remote default or named instance using SQL authentication

FortiClientEnterpriseManagement_6.0.2.XXXX_x64.exe SQLServer=<SQL_Server_name> SQLUser=<username> SQLUserPassword=<password> InstallSQL=0 ScriptDB=1 BackupDir=<backupdirectorypath>

Remote default or named instance using Windows authentication (domain user)

FortiClientEnterpriseManagement_6.0.2.XXXX_x64.exe SQLServer=<SQL_Server_name> WindowsUser=<username@domain.loc> WindowsUserPassword=<password> InstallSQL=0 ScriptDB=1 BackupDir=<backupdirectorypath>

For example, if installing FortiClient EMS and pointing to a remote named instance on a computer with DNS name WIN-088 using Windows authentication, with Windows username "janedoe", password "password123", the command would be as follows. This example also includes the optional SQLEncryptConnection option:

FortiClientEnterpriseManagement_6.0.2.XXXX_x64.exe SQLServer=WIN-0888 WindowsUser=janedoe@ems.loc WindowsUserPassword=password123 InstallSQL=0 ScriptDB=1 BackupDir=c:\backup\ SQLEncryptConnection=no

Remote existing database

Creating a backup directory

Prior to installing FortiClient EMS, create a backup directory on the database server and set the permissions as described below.

  1. On the database server, create a backup directory.
  2. Right-click the directory and select Properties.
  3. On the Security tab, ensure all users have full control of the directory.
Installation commands for remote existing databases

For remote instances using Windows authentication (domain user), do the following:

  1. Join the EMS and database servers to the same domain.
  2. Create a database user that maps to the domain user.
  3. In Local Group Policy Editor, add the domain user to the Log on as a service policy.

Database type

Command

Remote default or named instance using SQL authentication

FortiClientEnterpriseManagement_6.0.2.XXXX_x64.exe SQLServer=<SQL_Server_name> SQLUser=<username> SQLUserPassword=<password> InstallSQL=0 ScriptDB=1 BackupDir=<backupdirectorypath>

Remote default or named instance using Windows authentication (domain user)

FortiClientEnterpriseManagement_6.0.2.XXXX_x64.exe SQLServer=<SQL_Server_name> WindowsUser=<username@domain.loc> WindowsUserPassword=<password> InstallSQL=0 ScriptDB=1 BackupDir=<backupdirectorypath>

For example, if installing FortiClient EMS and pointing to a remote named instance on a computer with DNS name WIN-088 using Windows authentication, with Windows username "janedoe", password "password123", the command would be as follows. This example also includes the optional SQLEncryptConnection option:

FortiClientEnterpriseManagement_6.0.2.XXXX_x64.exe SQLServer=WIN-0888 WindowsUser=janedoe@ems.loc WindowsUserPassword=password123 InstallSQL=0 ScriptDB=1 BackupDir=c:\backup\ SQLEncryptConnection=no