| Description | This article provides the command to check the remote SQL database connection from the Primary/Secondary EMS |
| Scope | FortiClient EMS |
| Solution |
The below error can sometimes appear during upgrading EMS in the HA environment:
ERROR: FCEMSSetup: MSI_UpgradeDatabases, failed to launch '-U "******" -P "******" -S tcp:x.x.x.x,1811 -t 5 -Q "use master"' or exit was abnormal, retval=2, exitcode=0
At this stage, it is necessary to check the current admin that the user is using has full permission to access the remote EMS SQL database.
This can be achieved by using the below command:
sqlcmd -U "******" -P "******" -S tcp:x.x.x.x(ip address of remote DB server),1811(the default port number) -t 5 -Q "use master"
If the connection is OK, the output should appear as below:
The above command can help to exclude the database connection issue from the EMS upgrade process. |
