During the installation of ESET Security Management Center Server, the Mixed mode authentication (SQL Server authentication and Windows authentication) is required.
If you want to use Windows Authentification to log in to the MS SQL database in ESMC, follow the steps below.
This Knowledgebase article also applies to ESET Remote Administrator 6.x.
Follow the steps below to configure MS SQL to use Windows Authentication:
On the computer where ESMC Server is installed, navigate to the following directory:
C:\ProgramData\ESET\RemoteAdministrator\Server\EraServerApplicationData\Configuration\
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;
Figure 1-1
Click the image to view larger in new window
Figure 1-2
Figure 1-3
Figure 1-4
Figure 1-5
Click the image to view larger in new window
Figure 1-6
Windows Authentication is now used when accessing the ESMC MS SQL database.