NetResident - Network Content Monitoring Tool

Prev Page Next Page
System Requirements
What Network Content NetResident Can Analyze
What’s New in NetResident 3.0
NetResident Architecture
Deploying the Application
Before You Begin: Network Visibility
Step 1: Deploying the NetResident Service and Console
Step 2: Deploying NetResident Agents
Ensuring Connectivity Between the System Components
Tips and Tricks
Setting Up the Database
Step 1: Creating a New Database and Configuration File
Step 2: Selecting an SQL Server
Step 3: Selecting a Database Location and Name
Step 4: Setting Database Access Token
Step 5: Summary
Working with NetResident
Understanding the Difference Between the Display and Capture Filters
Remote Connections
Adding Exceptions to NetResident Agents
Manual SQL Server Installation
Analyzing Imported Capture Files
Frequently Asked Questions
Sales and Support

Manual SQL Server Installation

NetResident uses an SQL server instance for storing and retrieving captured network events. Normally, an SQL server is automatically installed by NetResident, as described in this help file. Automatic installation is highly recommended, as it helps you avoid mistakes when configuring the server. However, you can also install an SQL server yourself. This process is overviewed below. This overview is based on Microsoft® SQL Server® 2014 Service Pack 1; for other versions, the process might have minor distinctions.


Only the key installation steps are covered in this overview; less important steps, such as EULA acceptance, are skipped.

1. Once the installation package has been unpacked, the SQL Server Installation Center window shows up. Select New SQL Server.
2. On the Installation Type step, select Perform a New Installation.
3. On the Feature Selection step, check all the available components.
4. On the Instance Configuration step, select Named instance and enter any name for your SQL server. Copy and paste the same server name into the Instance ID field. The server name must be unique within the given computer. Be sure to remember the SQL server name that you have chosen. You will need it later, when you run the NetResident Database Manager.
5. On the Server Configuration step, select the Collation tab and then select Latin1_General_100_CI_AS from the drop-down list. The Service Accounts tab should not be modified.
6. On the Database Engine Configuration step, select Mixed Mode. This is very important; without this selection, NetResident will not be able to use the SQL server. Also, specify a strong password for the administrator (“sa”) account. Be sure to remember the administrative password. You will need it later, when you run the NetResident Database Manager.
7. Complete the installation. You can now refer to the Setting Up the Database chapter to configure NetResident to use your database.