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.
- On the database server, create a backup directory.
- Right-click the directory and select Properties.
- 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:
- Join the EMS and database servers to the same domain.
- Create a database user that maps to the domain user.
- 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.3.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.3.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.3.XXXX_x64.exe SQLServer=WIN-0888 WindowsUser=janedoe@ems.loc WindowsUserPassword=password123 InstallSQL=0 ScriptDB=1 BackupDir=c:\backup\ SQLEncryptConnection=no