Need to install a new Bigfix server with a different SQL DB Name

Usage and Config Platform
1

I need to create a new BF server, but the remote DB SQL instance already has the BFEnterprise and BFReporting databases in the SQL instance. I know if I use the same instance as my DEV Bigfix server it will overwrite it right? What can I do to use a different SQL DB Name? SQL 2012.

1 Like
2

You cannot customize the database names that BigFix creates/uses. You can only customize the SQL instance. So if you want to use a particular SQL Server that is already being used by another BigFix server, then you need to setup an additional SQL Server instance on that server. You typically have to run the SQL Server installer again, and it will give you the option to install an instance. Afterward you will will have essentially two different SQL Servers running on the same box, referenced by HOSTNAME and HOSTNAME\instanceName, respectively.

3

Thanks for letting me know. I hope my DBA can create another SQL instance.