HCL-BF-PRO-10 practice question 2 of 15

Which of the following is the correct upgrade process when performing a BigFix Windows Root server upgrade that uses a remote database?

Full set: 60 questions
Answer options
A: Upgrade the server installers using the Support Fixlets and run the server installer on the BigFix Server as a local administrator.
B: Upgrade using upgrade Fixlets from the console.
C: Upgrade the server installers and use the upgrade Fixlets from the BigFix Console.
D: Upgrade the server installers using the Support Fixlets and run the server installer on the BigFix Server as a user that has Sysadm permissions to the database server. Correct answer
Correct Answer:
D. Upgrade the server installers using the Support Fixlets and run the server installer on the BigFix Server as a user that has Sysadm permissions to the database server.
Explanation

When upgrading an HCL BigFix Root Server on Windows that utilizes a remote database, the installation process involves updating the database schema. To perform these modifications on the remote SQL server, the user account running the installer on the BigFix server must have the necessary permissions. The sysadmin fixed server role in SQL Server is required to ensure the installer can successfully connect to the remote database and apply all necessary schema changes, create or modify database objects, and update data as part of the upgrade.

Why Incorrect

A. Running the installer as only a local administrator is insufficient, as this account lacks the required permissions to modify the schema and objects on the remote database server.
B. While upgrade Fixlets can be used to download and stage the installer, they do not inherently grant the necessary database permissions. The installer must still be executed with appropriate credentials.
C. This option is incorrect because it omits the critical requirement for database sysadmin permissions, which is the central challenge when dealing with a remote database upgrade.

References

1. HCL BigFix Platform 10.0 Installation Guide, "Upgrading on Windows systems with remote database," Section: "Before you begin." The documentation states: "Before upgrading the server, ensure that the user who runs the installation has the system administrator privileges on the local computer and the sysadmin authority on the remote database." (URL: https://help.hcltechsw.com/bigfix/10.0/platform/Platform/Installation/cupgradingonwindowssystemsw.html)

2. HCL BigFix Platform 10.0 Installation Guide, "Upgrading on Windows systems with remote database," Section: "Procedure," Step 2. The guide instructs: "To upgrade the server components, run the installer as a user that has sysadmin permissions to the database server." This explicitly confirms the requirement. (URL: https://help.hcltechsw.com/bigfix/10.0/platform/Platform/Installation/cupgradingonwindowssystemsw.html)

Scroll to Top