Description
This article described that all the Microsoft SQL components that being installed during the FortiClient EMS installation shouldn’t get removed or uninstalled.
Any removal of the component will caused the SQL failure as well as the main EMS server functionality usage. With the components removal, it will contribute to the internal server error and the FortiClient Endpoint Management Server failed to startup or run.
Do not remove any underlying SQL components that installed alongside with the core FortiClient EMS server.
Solution
The following is the default SQL components that being installed alongside with the core FortiClient EMS server installed.
The list being referenced to both base GA version of 6.0 and 6.2, the component version may differ between the current GA version and earlier version.
FortiClient EMS version 6.2.1 GA:
- Microsoft SQL Server 2017 (64-bit)
- Microsoft SQL Server 2012 Native Client
- Microsoft SQL Server 2017 T-SQL Language Service
- Microsoft SQL Server 2017 Setup (English)
- Microsoft VSS Writer for SQL Server 2017
- Microsoft ODBC Driver 13 for SQL Server
- Microsoft SQL Server Browser for SQL Server 2017
- Microsoft Visual C++ 2017 Redistributable (x64)
- Microsoft Visual C++ 2017 Redistributable (x86)
FortiClient EMS version 6.0.8 GA:
- Microsoft SQL Server 2014 (64-bit)
- Microsoft SQL Server 2008 Setup Support Files
- Microsoft SQL Server 2012 Native Client
- Microsoft SQL Server 2017 Transact-SQL ScriptDom
- Microsoft SQL Server 2014 Setup (English)
- Microsoft VSS Writer for SQL Server 2014
- Microsoft ODBC Driver 11 for SQL Server
- Microsoft SQL Server Browser for SQL Server 2014
- Microsoft Visual C++ 2010 x64 Redistributable
- Microsoft Visual C++ 2010 x86 Redistributable
- Microsoft Visual C++ 2017 Redistributable (x64)
- Microsoft Visual C++ 2017 Redistributable (x86)
