Knowledgebase business article search

Use Windows authentication for connection to SQL Server database in ESET Security Management Center

Issue

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.

Details

This Knowledgebase article also applies to ESET Remote Administrator 6.

Solution

Follow the steps below to configure MS SQL to use Windows Authentication:

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

C:\ProgramData\ESET\RemoteAdministrator\Server\EraServerApplicationData\Configuration\
  1. 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 ESMC Server.

  1. Click Start and run Services.
     
  2. Right-click the ESET Security Management Center Server service and select Properties.

    Figure 1-1
    Click the image to view larger in new window

  3. Click the Log On tab and click Browse.

    Figure 1-2

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

    Figure 1-3

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

    Figure 1-4

  6. Right-click the ESET Security Management Center Server service and select Restart.

    Figure 1-5
    Click the image to view larger in new window

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

  8. Windows Authentication is now used when accessing the ESMC MS SQL database.



Was this information helpful?