Install Guide
Item Write down your information
Database server port
Database user name For security reasons, only record the database username in a
secure location.
Database password For security reasons, only record the database password in a
secure location.
Prepare the Database
If you plan to use an external database, prepare the database by performing the task that corresponds to your database type.
NOTE: If you want to store Data Collector data in the embedded database, skip this step.
• Prepare a Microsoft SQL Server Database
• Prepare a MySQL Database
Prepare a Microsoft SQL Server Database
Set up the Microsoft SQL Server database or Microsoft SQL Server Express database for the Data Collector.
1. If necessary, install the database software.
2. Make sure you have the credentials for a database administrator account with privileges equivalent to the default sa account.
3. Congure the database for mixed-mode authentication (SQL Server and Windows Authentication mode).
4. Start the SQL Server Conguration Manager application.
5. Set the TCP/IP ports.
a. In the navigation pane, expand SQL Server Network Conguration.
b. Click Protocols for MSSQLSERVER or Protocols for SQLEXPRESS.
c. Right-click TCP/IP and select Properties. The TCP/IP Properties dialog box appears.
d. Click the IP Addresses tab.
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.
16
Planning and Preparation