[KB7831] Use Windows authentication for connection to SQL Server database in ESET PROTECT (8.x)

Issue

  • During the ESET PROTECT Server installation, the Mixed mode authentication (SQL Server authentication and Windows authentication) is required
  • You want to use Windows Authentification to log in to the MS SQL database in ESET PROTECT

Solution

Windows authentication can disable upgrades

If you use the Windows authentication mode to connect the database with the Windows user account, you cannot update the connected component (ESET PROTECT Server or MDC) using the Components Upgrade task.

We recommend that you use a dedicated database user to access the database. Make sure to set access rights for the user to access the necessary directories.

Configure MS SQL to use Windows Authentication

  1. On the computer where ESET PROTECT Server is installed, navigate to the following directory:

    C:\ProgramData\ESET\RemoteAdministrator\Server\EraServerApplicationData\Configuration\

  2. Edit and save the startupconfiguration.ini file so that it contains the following:

    DatabaseType=MSSQLOdbc
    
    DatabaseConnectionString=Driver={SQL Server Native Client 11.0};Server=.\ERASQL;Database=era_db;Trusted_Connection=yes;
Default SQL Server instance and database names:

The above example contains the default SQL Server instance name (ERASQL) and database name (era_db) that are created when MS SQL Server Express is installed together with the ESET PROTECT Server.

  1. Click Start and run Services.

  2. Right-click ESET PROTECT Server and select Properties.

Figure 1-1
  1. Click Log On and click Browse.

Figure 1-2
  1. Type the name of the user that logs into Windows (Administrator in this example) and click OK.

Figure 1-3
  1. Type the password in the Password and Confirm password fields and click OK.

Figure 1-4
  1. Right-click ESET PROTECT Server and select Restart.

Figure 1-5
  1. Optionally, you can disable the mixed-mode authentication:

    1. Download and install Microsoft SQL Server Management Studio.

    2. Change the Server authentication to Windows Authentication mode, as described here.

Figure 1-6
  1. Windows Authentication is now used for connection to the ESET PROTECT MS SQL database.