[KB7798] Install Microsoft SQL Server (database) and ESET PROTECT Server on separate computers (8.x – 10.x)
Apache HTTP Proxy users
ESET Bridge replaces Apache HTTP Proxy in ESET PROTECT 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.
Open the x64 folder that you extracted from the ESET PROTECT 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).
Click New SQL Server stand-alone installation or add features to an existing installation.
Read the SQL Server License Terms, select the check box next to I accept the license terms and Privacy Statement and then click Next.
After support files have finished installing, leave the default values selected and click Next.
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.
Keep the default settings and click Next.
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.
III. Allow TCP/IP connections to the SQL database on Computer 1
Allow TCP/IP connections to the SQL database on Computer 1
Click Start → All Programs → Microsoft SQL Server → Configuration Tools → SQL Server Configuration Manager.
Expand SQL Server Network Configuration → Protocols for SQLEXPRESS, select the database instance that will be used with ESET PROTECT and then double-click TCP/IP.
Select Yes from the drop-down menu next to Enabled and click Apply. Click OK if you are prompted.
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.
Select the SQL Server Services entry from the drop-down menu, right-click the database instance that will be used with ESET PROTECT, and select Restart from the context menu. When you are finished, continue to part IV below.
IV. Install ESET PROTECT Server on Computer 2
Install ESET PROTECT Server on Computer 2
Open the x64 folder that you extracted from the ESET PROTECT All-in-one installer file and double-click Setup.
Select Install and click Next.
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.
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.
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
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.
Select No to create a new database user.
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.
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.
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.
Continue with the ESET PROTECT Server installation and other ESET PROTECT 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 installer will create a link to ESET PROTECT Web Console in your Start menu. Click Finish to close the installer.