User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed – SQL Server Reporting Services Error

Leave a comment (0) Go to comments

User ‘DBATAG-DEMO\cluadmin’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

I received this error, when I was trying to configure SQL Server Reporting Services for “Scale-OUT Deployment” for NLB configuration.

User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed   SQL Server Reporting Services Error SQL Error Reporting Services report Server Configuration

I was logged in as Domain / Enterprise Administration account still getting this message. I have already worked on this issue sometime back. So immediately as a workaround

WORKAROUND / FIX / SOLUTION :


Start the Internet Explorer with Administrative Privileges by Right Click on Internet Explorer and select “Run as Administrator

User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed   SQL Server Reporting Services Error SQL Error Reporting Services report Server Configuration

This will temporarily fix this issue at session level.

User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed   SQL Server Reporting Services Error SQL Error Reporting Services report Server Configuration

To Solve this Issue Permanently / Solution

  1. Start Windows Internet Explorer.
  2. On the Tools menu, click Internet Options.
  3. Click Security.
  4. Click Trusted Sites.
  5. Click Sites.
  6. Under Add this Web site to the zone, type http://<var>ServerName</var>. If you are not using HTTPS for the default site, click to clear the Require server certification (https:) for all sites in this zone check box.
  7. Click Add.
  8. Repeat step 7f and step 7g to add the http://localhost URL, and then click Close.
  9. Note This step enables you to start Internet Explorer and open either the localhost or the network computer name of the server for both the Report Server application and the Report Manager application.
  10. Create role assignments that explicitly grant you access together with full permissions. To do this, follow these steps:
  11. Start Internet Explorer together with the Run as administrator option. To do this, click Start, click All Programs, right-click Internet Explorer, and then click Run as administrator.
  12. Open Report Manager URL, which you configured using Reporting Services Configuration Manager    User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed   SQL Server Reporting Services Error SQL Error Reporting Services report Server Configuration
  13. In the Home dialog box, click Properties.
  14. Click New Role Assignment.
  15. Type a Windows user account name by using the following format:
  16. Click to select the Content Manager check box.
  17. Click OK.
  18. In the Home dialog box, click Site Settings.
  19. Click Configure site-wide security.
  20. Click New Role Assignment.
  21. Type a Windows user account  User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed   SQL Server Reporting Services Error SQL Error Reporting Services report Server Configuration
  22. Click System Administrator.
  23. Click OK.
  24. Close Report Manager.
  25. Use Internet Explorer without the Run as administrator option to reopen Report Manager.

This should FIX this issues and you should directly get into Reporting Manager

EOF - User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed – SQL Server Reporting Services Error, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.