Description
This article describes how to validate account privileges in Windows to access the database, when the user attempts to upgrade the console and the message 'Unable to connect to the FCM database' appears.
Scope
FortiClient EMS Server version 7.0+ and 7.2.+.
Solution
The most common reason for this message is that the Windows account does not have administrator privileges, to validate these, run a CMD with administrator privileges and execute the next command line:
>sqlcmd -E -S.\fcems -d fcm_root
Or:
>sqlcmd -E -S.\fcems -d fcm_default
It should show 1>, meaning the Windows account has sufficient privileges.
If the command throws an error, check the Windows account privileges.
Note:
If the account has enough privileges, execute the EMS installer as Administrator.
