Installing MS SQL Server for BigFix Inventory on Windows

BigFix Inventory that is installed on Windows requires MS SQL Server as a database. However, the software is not delivered as part of BigFix Inventory. Ensure that you install MS SQL Server before you proceed with the installation of the BigFix Inventory server.

About this task

The database can be installed on the same computer as the BigFix Inventory server or on a separate one. You can also reuse the MS SQL Server that you installed for the BigFix platform.

Procedure

For instructions on installing SQL Server, see: SQL Server installation.

Configuring SQL Server Express

If you use the SQL Server Express Edition, you need to complete post-installation configuration.

Procedure

  1. Open the local SQL Server Configuration Manager for the SQL Server Express. For detailed instructions, see: SQL Server Configuration Manager.
  2. In the left pane, expand SQL Server Network Configuration and select Protocols for MSSQLSERVER.
  3. On the right pane, make sure that the TCP/IP communication is enabled. Otherwise, right-click TCP/IP and select Enable.
  4. Next, right-click TCP/IP and select Properties.
    1. Enable all non-VMnet IP addresses.
    2. In the IPAll entry, set the TCP port to 1433.
    3. Confirm the changes by clicking OK.
  5. Return to SQL Server Configuration Manager, and in the left pane, select SQL Services.
  6. In the right pane, right-click SQL Server (MSSQLSERVER) and select Restart.
  7. Use the following command to test the configuration:
    netstat -an:C:\>netstat -an | find "1433"
    The command should return the following response:
    TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING TCP [::]:1433 [::]:0 LISTENING