View Source

Security Privilege

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 exception	SeSecurityPrivilage
Cause	The server account 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: Go to Target Server Windows Settings Local Security Policy Local Policies User Rights Assignment on the server you are trying to install on 2. Assign your logged-in account (e.g. [domain]\[username]) 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.

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 exception	UnauthorizedAccessException
Cause	The path parameter specified a directory that is read-only.-or- This operation is not supported on the current platform.-or- The caller does not have the required permission.
Solution	In order to fix this, we need to go to the SQL Server installation directory and make sure that the user under which SQL Secure collector is running have enough access permissions on all the folders and files inside the installation directory(uncheck "Read Only" checkbox in the properties) and not Read-only access.
New Error Message	Collector tried accessing an unauthorized directory/credentials saved on the target server does not have the required permission.