This article describes how to create an extra Microsoft SQL admin account for EMS installation and upgrade.
Scope
FortiClient EMS.
Solution
Sometimes when using CLI to perform EMS installation or upgrade for remote Microsoft SQL Server, it is preferable to use a different admin account.
In this scenario, it is possible to create a different admin account to manage this.
Step 1: Download and install SQL Server Management Studio.
Step 2: Login to SMSS by using Windows authentication.
Step 3: Expand Security > Logins, ‘right-click’ ‘Logins’, and select ‘New Login’. Input the Login name, select ‘SQL Server authentication’ and give the password as well.
The most important thing is that it is necessary to give the ‘sysadmin’ role to this new account as shown in the below screenshot. Select ‘OK’ to complete the creation.
Once this new admin account is created then it is possible to use this account to remotely upgrade EMS via CLI.