[KB7798] Install Microsoft SQL Server (database) and ESET PROTECT Server on separate computers

Solution

Apache HTTP Proxy users

ESET Bridge replaces Apache HTTP Proxy in ESET PROTECT On-Prem version 10. All ESET product versions compatible with Apache HTTP Proxy are in Limited Support status. If you currently use Apache HTTP Proxy, we recommend that you migrate to ESET Bridge.

This solution is divided into four parts. Click each part to expand the step-by-step instructions.

  1. Prerequisites
  2. Manually install SQL Express on Computer 1
  3. Allow TCP/IP connections to the SQL database on Computer 1
  4. Install ESET PROTECT Server on Computer 2

I. Prerequisites


Prerequisites
 

II. Manually install SQL Express on Computer 1


Manually install SQL Express on Computer 1
 
  1. Open the x64 folder that you extracted from the ESET PROTECT On-Prem All-in-one installer file, navigate to Installers and double-click SQLEXPR_2019_x64_ENU or SQLEXPR_2014_ENU depending on the version of SQL Express you want to install (the example below shows the SQL Server 2019 installation).
Figure 1-1
  1. Click New SQL Server stand-alone installation or add features to an existing installation.
Figure 1-2
  1. Read the SQL Server License Terms, select the check box next to I accept the license terms and Privacy Statement and then click Next.
Figure 1-3
  1. After support files have finished installing, leave the default values selected and click Next.
Figure 1-4
  1. The default name for your database instance is SQLExpress; you can type a new name into the Named instance and Instance ID fields if you prefer to use a custom name and click Next.
Figure 1-5
  1. Keep the default settings and click Next.
Figure 1-6
  1. In the Database Engine Configuration window, select Mixed Mode (SQL Server authentication and Windows authentication), type a password for your database into the Enter password and Confirm password fields and then click Next.
Figure 1-7
  1. When SQL Server installation completes, click Close. Continue to part III below.
Figure 1-8

III. Allow TCP/IP connections to the SQL database on Computer 1


Allow TCP/IP connections to the SQL database on Computer 1
 
  1. Click StartAll Programs Microsoft SQL Server Configuration Tools SQL Server Configuration Manager.
Figure 2-1
  1. Expand SQL Server Network ConfigurationProtocols for SQLEXPRESS, select the database instance that will be used with ESET PROTECT On-Prem and then double-click TCP/IP.
Figure 2-2
  1. Select Yes from the drop-down menu next to Enabled and click Apply. Click OK if you are prompted.
Figure 2-3
  1. Click the IP Addresses tab and locate the IPAII section. Set the TCP Port value to 1433 and click Apply. Click OK if you are prompted and click OK to exit the TCP/IP window.
Figure 2-4
  1. Select the SQL Server Services entry from the drop-down menu, right-click the database instance that will be used with ESET PROTECT On-Prem, and select Restart from the context menu. When you are finished, continue to part IV below.
Figure 2-5

 


IV. Install ESET PROTECT Server on Computer 2


Install ESET PROTECT Server on Computer 2
 
  1. Open the x64 folder that you extracted from the ESET PROTECT On-Prem All-in-one installer file and double-click Setup.
  1. Click Next.
Figure 3-1
  1. Select Install and click Next.
Figure 3-2
  1. Read the End User License Agreement, select I accept the terms in the license agreement if you agree. Deselect the check box Participate in product improvement program if you do not agree to send crash reports and telemetry data to ESET. If the check box is left selected, telemetry data and crash reports will be sent to ESET. Click Next to continue.
Figure 3-3
  1. Deselect the check box next to Microsoft SQL Server Express. Optionally, select the check box next to ESET Bridge Proxy if you want to install that component. Click Install when you are ready.

    If you are prompted to install prerequisites, follow the link provided, install the prerequisites and then click Retry.

Figure 3-4
  1. Click Next.
Figure 3-5
  1. Select or type the below data and click Next:

    • Database: MS SQL Server
    • ODBC driver: SQL Server
    • Database name: era_db (This is the default database name; you can provide another name. If the database does not exist, the installer will create it.)
    • Hostname: Hostname of the computer where SQL database is installed
    • Use named instance: Leave unchecked
    • Port: 1433
    • Username: sa
    • Password: the password you set in step 7 from section II of this article. 
Install ESET PROTECT Server on the same computer where SQL Server is installed

To install ESET PROTECT Server on the same computer where SQL Server is already installed, in the Database drop-down menu, select MS SQL Server via Windows Authentication. In the Hostname field, type localhost.

Figure 3-6
  1. Select No to create a new database user.
Figure 3-7
  1. In the Database user for PROTECT window, provide the new Database username (era_user is the default username) and type the Password and Password confirmation and click Next.
Figure 3-8
  1. Type your login password for the ESET PROTECT Web Console into the Password and Password confirmation fields. Make sure to record this password for later use and click Next.
Figure 3-9
  1. In the Certificate information window, you can customize your Certificate Authority. The only mandatory fields are Authority common name and Certificate validity. Type any information about your Certificate Authority that you want to add. If you create a password, make sure that you record it because all client computers using this certificate will require that password to use the certificate. Click Next when you are finished.
Figure 3-10
  1. Select Activate with License Key and type your License Key into the appropriate field, or select Activate later.
Figure 3-11
  1. Continue with the ESET PROTECT Server installation and other ESET PROTECT On-Prem components. At the Installation successful window, click the URL link to open ESET PROTECT Web Console. We recommend that you bookmark or note this link for future reference. By default, the ESET PROTECT On-Prem installer will create a link to ESET PROTECT Web Console in your Start menu. Click Finish to close the installer.
Figure 3-12
  1. Locate and deploy the ESET Management Agent to client computers.