Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

User '' does not have required permissions, SSRS 2008 on Windows 8

When you try to log into SSRS's root site at http:// (servername)/Reports it displays:

User '' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

This is on a 64 bit edition of Windows 8 Pro, running SQL Server 2008 enterprise. Everything should be using the local system as the account of execution.

I have tried changing the execution account as my user which is admin, I have added the site as the trusted site, I have UAC turned completely off, I have tried to hit the site with IE AS ADMIN, Chrome, and Firefox. Everything I try the site states back that I don't have the rights. I go into SQL Server and ensure my roles are everything for my user. It does not care. I am currently reinstalling the SSRS node of the SQL Server install but am curious if anyone else had this issue yet.

I am going to try to change my account to a 'local' account as I am thinking that may be an issue yet I don't understand why SQL Server can recognize my login integrated just fine. Honestly I never ran into this and am wondering if this is an issue just with Windows 8 accessing SQL Server 2008. I would upgrade but I have a full version of SQL Server 2008 and not of 2012 so I am hesitant to just upgrade unless Express 2012 will come with Business Intelligence Development Studio and SSRS site with tools.

EDIT: 3-8-2016:

  1. No answer with: "Just turn on site settings" is valid as this is the first time installing as the admin of the server or machine locally and not able to access the landing page as that admin.
  2. No answer with: "Just run IE as admin" will work last I tested that.
  3. Answers with "Trusted SITE settings MAY WORK" on Windows 8 and higher as I had a similar problem to this with Windows 10 and on Windows 10 it did fix it. I am not going to rollback two OS versions to check at home though, sorry.

I don't get how this question can be existing for a while and people are now on a mission to claim it is duplicate when the very answer is different than the potential duplicate. That whole thread deals with someone able to get into the site with elevated permission and just not setting up roles and users after the fact. This is the main user of the machine not getting to the landing page as an admin to the site listed as the default landing. Not even the same ballpark. Getting into a page as an admin to let local users in versus the highest level God user not getting in is not the same.

like image 975
djangojazz Avatar asked Jan 21 '13 05:01

djangojazz


People also ask

Does not have required permissions SSRS?

Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. Actually, this issue usually occurs if the current user doesn't have a sufficient permission to access Report Manager URL in SSRS.

How do I add user permissions to SSRS?

In SSRS, go to Site Settings, and create a new role assignment so that you can assign the desired Active Directory group to the “System user” role in SSRS. By default, all authenticated users are assigned to the System User role. In SSRS, go to the Home folder, and then click Folder settings.

How do I grant access to a report server?

Select Add group or user. In Group or user, enter a Windows domain user or group account in this format: <domain>\<account>. If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment. Select a system role, and then select OK.

How do I restrict access to SSRS reports?

Denying Access to My Reports You can prevent users from accessing My Reports by: Disabling My Reports on the Site Settings page. For more information, see Enable and Disable My Reports.


1 Answers

Everything in this answer is true but don't reinstall all of SSRS thats nonsense...

Windows 8

  1. Disable UAC
  2. Enable Administrator Account (You can go to Control Panel > Computer Management > Users)
  3. Restart PC
  4. Run IE ad Administrator when prompted login with your local Administrator account you enabled.
  5. You will need to adjust site settings security and folder settings security. Easy fast fix just add "Everyone" in both of those with full rights.

Problem solved!

like image 51
Austin McLaughlin Avatar answered Sep 26 '22 02:09

Austin McLaughlin