Security Privilege
Corresponds to warning on UI / Exception in Logs: |
|
---|---|
Type of exception | SeSecurityPrivilage |
Cause | The account under which Sql Secure collector is running does not have enough permissions in Active Directory |
Resolution | In order to fix this, perform following steps:
|
New Error Message | Credentials/Authentication being used to collect details from target server does not have the required file. |
Unuthorized Access Exception.
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.
Example from collector logs:
Failed to get file permissions for \\MACHINE-NAME\C$\Program Files\Microsoft SQL Server\MSSQL13.MSSQL16\MSSQL\Binn\Xtp\gen\include\hkengdef.h: System.UnauthorizedAccessException: Attempted to perform an unauthorized operation.
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 installation directory(uncheck "Read Only" checkbox in the properties) and not Read-only access.