Creating an account in the MS SQL database

To receive Kaspersky Security Center events from MS SQL, a user account is required that has the rights necessary to connect and work with the database.

To create an account for working with MS SQL:

1. Log in to the server with MS SQL for Kaspersky Security Center installed.
2. Using SQL Server Management Studio, connect to MS SQL using an account with administrator rights.
3. In the Object Explorer pane, expand the Security section.
4. Right-click the Logins folder and select New Login from the context menu.

   The Login - New window opens.

5. On the General tab, click the Search button next to the Login name field.

   The Select User or Group window opens.

6. In the Enter the object name to select (examples) field, specify the object name and click OK.

   The Select User or Group window closes.

7. In the Login - New window, on the General tab, select the Windows authentication option.
8. In the Default database field, select the Kaspersky Security Center database.

   The default Kaspersky Security Center database name is KAV.

9. On the User Mapping tab, configure the account permissions:
   1. In the Users mapped to this login section, select the Kaspersky Security Center database.
   2. In the Database role membership for section, select the check boxes next to the db_datareader and public permissions.
10. On the Status tab, configure the permissions for connecting the account to the database:
    • In the Permission to connect to database engine section, select Grant.
    • In the Login section, select Enabled.
11. Click OK.

    The Login - New window closes.

To check the account permissions:

1. Run SQL Server Management Studio using the created account.
2. Go to any MS SQL database table and make a selection based on the table.