NetResident uses an SQL server
instance for storing and retrieving captured network events.
Normally, an SQL server is automatically installed by NetResident,
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.
installation package has been unpacked, the SQL Server
Installation Center window
shows up. Select New SQL Server.
Installation Type step, select Perform a New
Selection step, check all the
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.
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
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.
installation. You can now refer to the Setting Up the Database chapter to configure NetResident to use your