[KB7831] Use Windows Authentication for connection to SQL Server database in ESET PROTECT On-Prem

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 On-Prem

Solution

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;

3. Click Start and run Services.

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

5. Click Log On and click Browse.

6. Type the name of the user that logs into Windows (Administrator in this example) and click OK.

7. Type the password in the Password and Confirm password fields and click OK.

8. Right-click ESET PROTECT Server and select Restart.

9. 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.

10. Windows Authentication is now used for connection to the ESET PROTECT On-Prem MS SQL database.