Install Guide

Table Of Contents
Figure 1. TCP/IP Properties Dialog Box IP Addresses Tab
e. Under IPALL, make sure the TCP Port is set to a valid port number. The default TCP port for SQL Server is 1433.
f. Click Apply and click OK to close the dialog box.
6. Enable TCP/IP protocol:
a. In the navigation pane, click Protocols for MSSQLSERVER or Protocols for SQLEXPRESS.
b. Right-click TCP/IP and select Enable.
7. Restart SQL Server.
a. In the navigation pane, click SQL Server Services.
b. Right-click SQL Server and select Restart.
Prepare a MySQL Database
Set up the database permissions for the Data Collector.
Steps
1. If necessary, install the database software.
2. Make sure that you have administrator rights from remote servers (preferably root user).
3. Make sure the database admin user has the global CREATE USER, RELOAD, and SELECT permissions, and has full
permissions to the compmsadb database.
Enter the following commands from the MySQL admin tool, where root is the name of the admin user:
grant create user, reload, select on *.* to 'root'@'%';
grant all privileges on compmsadb.* to 'root'@'%' with grant option;
flush privileges;
16
Planning and Preparation