Versions Compared

Old Version 32

changes.mady.by.user Alejandra Barrientos

Saved on

compared with

New Version 33

changes.mady.by.user Alejandra Barrientos

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Corresponds to warning on UI / Exception in Logs:
  • Failed to load file permissions for target SQL Server [UI]
  • Failed to load file permissions for '{0}' audit folder [UI]
  • Failed to load file permissions for SQL Services on target SQL Server [UI]
Type of exceptionSeSecurityPrivilageSeSecurityPrivilege
CauseThe Server Collection Account configured in the server properties and under which SQL Secure collector is running, does not have enough permissions in the Active Directory.
Solution

In order to fix this, perform the following steps:

  1. Go to the Target Server Windows Settings
  • Local Security Policy.
  • Local Policies.
  • User Rights Assignment on the server you are trying to install on.

2. Look for the SQL Server collection account used to connect to audited SQL Servers and assign it the following rights:

  • Back up files and directories.
  • Debug Programs.
  • Manage auditing and security log.
  • Restore files and directories.
  • Take ownership of files or other objects.
3. Once you have done this, logout then log back in again.
New Error Message

Credentials/Authentication being used to collect details from the target server does not have the required File Permissions.

...