Allow TCP/IP connections to the SQL database on port 1433, as described here.
Create a database and database user that you will use to access the database.
Ubuntu 20.04:
apt install curl
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
apt-get update
ACCEPT_EULA=Y apt-get install msodbcsql17
Red Hat Enterprise Linux 7/CentOS 7:
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
yum remove unixODBC-utf16 unixODBC-utf16-devel
ACCEPT_EULA=Y yum install msodbcsql17
chmod +x server-linux-x86_64.sh
sudo ./server-linux-x86_64.sh \
--skip-license \
--db-type="MS SQL Server" \
--db-driver="ODBC Driver 17 for SQL Server" \
--db-hostname=10.20.30.40 \
--db-port=1433 \
--db-admin-username=user \
--db-admin-password=pAssword1 \
--server-root-password=pAssword1 \
--db-user-username=user \
--db-user-password=pAssword1 \
--cert-hostname="10.20.30.50;ubuntu1"
To improve security, enable an encrypted connection between the ESET PROTECT Server and the SQL database.
Perform the steps below on the ESET PROTECT Server Linux machine:
root
.eraserver
service:service eraserver stop
StartupConfiguration.ini
file:nano /etc/opt/eset/RemoteAdministrator/Server/StartupConfiguration.ini
Encrypt=yes;TrustServerCertificate=yes;
Below is an example of the StartupConfiguration.ini
file (replace the parts highlighted in yellow with your values):DatabaseType=MSSQLOdbc
DatabaseConnectionString=Driver=ODBC Driver 17 for SQL Server;Server=10.20.30.40,1433;Uid=era_user;Pwd={SecretPassword};CharSet=utf8;Database=era_db;Encrypt=yes;TrustServerCertificate=yes;
eraserver
service:service eraserver start