I am trying to install a new BigFix Server using a local SQL Server database. During the installation, I am encountering the error shown in the attached screenshot.
Could anyone help identify the root cause and suggest a resolution?
Environment Details:
BigFix Version: 11.0.6
SQL Server Version: SQL standard 2022
Database Type: Local SQL Server
Operating System: Windows 2022 (21H2)
I have attached the error screenshot for reference.
Check if the user has the sysadmin privileges.
As mentioned
Important:
When installing or upgrading BigFix, the user account performing the installation or upgrade must have sysadmin server role in SQL Server.
When working with a remote instance of SQL Server, the AD domain service account must have dbo rights, that is db_owner on the BFEnterprise and BESReporting databases.
Start with sysadmin server role to perform the installation or upgrade, then back off the privileges to db_owner after the product is up and running.
If you need to know how to add a user to sysadmin / db_owner - Join a Role - SQL Server | Microsoft Learn
