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 |
|---|---|
|
FortiClientEnterpriseManagement_6.0.1.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.1.XXXX_x64.exe SQLServerInstance= SQLService=<instance_name> SQLCmdlineOptions="/INSTANCENAME=" InstallSQL=0 ScriptDB=1 |
|
Local named instance using SQL authentication |
FortiClientEnterpriseManagement_6.0.1.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.1.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.1.XXXX_x64.exe SQLUser=janedoe SQLUserPassword=password123 InstallSQL=0 ScriptDB=1 SQLServerInstance=database000 SQLService=mssql$database000 SQLCmdlineOptions="/INSTANCENAME=database000"