Install 2 different BigFix database instance in one windows server

1

Can we install two different BigFix database instances on one Windows Server? If yes, please share the documentation link.

2

I assume you mean that you got a Microsoft SQL Server installed on a Windows machine and you wish to Install on the SQL Server two different BFEnterprise and BESReporting databases.

After you Install the first SQL Server you will need to create an additional Instance of SQL Server on that Windows OS machine and provide it with a different Instance ID and after that configure a different port for SQL connectivity - Install Using Graphical User Interface - SQL Server | Microsoft Learn

After you configured both of those instances of SQL Server - you can reference them individually on each BigFix Installation

1 Like
3

We have one MS SQL database server and we are trying to create new instance on same SQL server and after that can we install another bigfix server on new instance?. Already 1 BigFix server is installed on same SQL server

4

It’s exactly what I wrote , work with the official documentation from Microsoft and create a new instance of SQL Server

5

To be clear, you need two different BigFix Servers (two different hosts running BESRootServer, FillDB, etc.) but both servers can point to the same SQL Database Server to store their databases.

6

I have not done this, but believed it was possible, and experts agreed.

I just wanted to comment that… I would take great caution and validate at every step you are not accidently connecting to the wrong instance. If this is temporary maybe not a huge deal, but I feel like long term, this opens up the possibility of person accidently crossing DB configs and messing something up.

If your SQL instance is virtualized, I would recommend snapshotting before any major work. Doing this in our environment, has saved my butt many times, and reduced manual work. If an upgrade goes wrong or I didn’t like something, I have reverted more than once and tried again. Thankfully it’s always been in our Dev or QA instances of BigFix, but still!

7

I would also consider performance impacts having two BigFix databases on the same machine, especially if they have to manage many devices.