Installing MS SQL Server for License Metric Tool on Windows (BigFix scenario)

Edit online

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

About this task

  • Ensure that the MS SQL Server that you install meets all requirements. For more information, see: MS SQL Server.
  • The database can be installed on the same computer as the License Metric Tool server or on a separate Windows computer. Installation of MS SQL Server that is used for License Metric Tool is not supported on Linux.
  • You can 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

Edit online

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 | 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