Skip to main content

Permissions Granted Are Insufficient in SQL Server Reporting Services

Symptoms​

  • The following error is prompted when accessing SSRS Report Manager or viewing reports in Netwrix Auditor:
The permissions granted to user '%domain\\user%' are insufficient for performing this operation. (rsAccessDenied)
  • In older SSRS versions, the error reads as follows:
User "%domain\\user" does not have required permissions.
Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

Causes​

  1. User Account Control (UAC) is enabled in the Netwrix Auditor server preventing the access.
  2. The active scripting support is disabled.

Resolutions​

Cause #1 − Disable UAC in the Netwrix Auditor server​

  1. Launch Registry Editor, and locate the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System key.
  2. Locate the EnableLUA subkey. Right-click it, select Modify > change the value data to 0, and click OK.
  3. Reboot the server for changes to take effect.

Cause #2 − Enable active scripting support in the Netwrix Auditor server​

  1. In Control Panel, select Internet Options.

NOTE: Alternatively, you can find the Internet Properties menu via the Search bar.

  1. Under the Security tab, click Custom level.
  2. Locate the Scripting node, and check the Enable option under the Active scripting subnode.
  3. Click OK > OK twice to save the changes. A reboot is required for changes to take effect.