Database requirements
The database stores all the data retrieved from the clients. Before installing the BigFix server, ensure that the database requirements are met.
A pre-upgrade check Fixlet is available to perform a set of checks to verify if the BigFix server can be successfully
upgraded to V9.5.X. A log file is created in the BigFix server directory
containing details about the executed steps. If these checks fail, a
preupgrade-Version 9.5.X-<datetime>.err
log file is
created in the BigFix server
directory. If these checks end successfully, a preupgrade-Version
9.5.X.out
log file is created in the BigFix server directory. X
is the modification level. This task is not relevant only when all the checks are
completed successfully.
The BigFix server on Windows systems supports the following configurations:
- Local or remote Microsoft SQL Server 2008, 2008 R2, 2012, 2014 or 2016.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 isdb_owner
on the BFEnterprise and BESReporting databases. Start withsysadmin
server role to perform the installation or upgrade, then back off the privileges todb_owner
after the product is up and running.Important: When working with SQL Server, ensure that you satisfy the following prerequisites for the Microsoft SQL database collation:- The database collation must be case insensitive.
- The database collation at the server, database and column level must be set to the same value.
- At the SQL server instance level
SELECT ServerProperty('Collation')
- At the database level
SELECT DatabasePropertyEx('BFEnterprise','Collation')
- At the column level in the BFEnterprise and BESReporting databases
SELECT C.name, O.name, C.collation_name
Note: On Windows systems, theSQL Server Native Client
driver is a prerequisite.
- Local or remote Microsoft SQL Server 2008, 2008 R2, 2012, 2014 or 2016.
The BigFix server on Red Hat Enterprise Linux systems supports the following configurations:
- If the DB2 server is installed locally: DB2 V10.5 Enterprise Server Edition / V11.5 GA / 11.5.4 Standard Edition 64-bit or DB2 10.5 Workgroup Server Edition 64-bit.
- If the DB2 server is installed remotely: IBM Data Server client V10.5 / V11.5 GA.
db2licm -l
command. On the computer where the DB2 server is installed, you receive a detailed report, if only the client is installed you receive an empty report. To check which DB2 version is installed, run thedb2level
command.
- Do not change the name of BigFix databases; if you do, upgrades might fail.
-
The DB2 instance names used to install the BES Root Server cannot contain the following special characters: blanks, tabs
\t
, returns\n
and; & | " ' < >
. Database passwords must contain only ASCII characters, otherwise the installation might fail. - To successfully install the BigFix server on Linux systems, ensure that you unset the DB2 registry variable DB2_COMPATIBILITY_VECTOR. This variable should be set to null.
For more information about the supported database versions, see Detailed system requirements.