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

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.

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.

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)