question

MiguelAlvarez22 avatar image
MiguelAlvarez22 asked

Getting: "SQL Server Reporting Services Error User 'DESKTOP-7CH23GV\a_c_d' does not have required permissions"

I just configured SQL Reporting Services and when I click the Report Manager URL (from the RS Configuration Manager) I get the following errors when using my default browser (Chrome): "SQL Server Reporting Services Error User 'DESKTOP-7CH23GV\a_c_d' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed." INFO: User: a_c_d is the main and (originally) only user account in the box, that was the account used to install SQL Server and Reporting Services. It is of Administrator type. The machine is a Lenovo running Windows 10, and SQL Server 2014. If I use (the browser) Edge I get no error but the page is BLANK (empty). I have found in other sites the suggestion about playing with the Home or Root folder settings options, from inside the Report Manager, however, in my case the problem is that I can NOT access that page. I even tried, as per some other suggestions, adding the machine to the Trusted Sites (using Chrome, since Edge does not allow that, apparently). Still no joy. Any suggestions you could offer to resolve this problem will be appreciated. Michael
sql server 2014
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered
This is the process that worked for me: 1. Add http:// to your trusted sites. (Sounds like you've done this.) 2. Use Run As Administrator on IE (haven't tried with Edge) to get into Report Manager. 3. Add your login as a System Administrator in Site Security. After that, it should work. It's because, even when you are a machine admin, IE doesn't normally runs with reduced privileges so Report Manager doesn't get the message. (Can you tell I'm not a web security pro?!)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

MiguelAlvarez22 avatar image
MiguelAlvarez22 answered
Thank you David for that input. However, MS does not allow for Edge to be Run As Administrator. On the original icon menu options "Run As Administrator" is not available. If one finds MicrosoftEdge.exe in the file system and sees the "Run As Administrator" option, and uses it, it still does not work. The program does not launch. I was able to Run as Administrator both Chrome and Firefox, however, the problem remains, I still get a modified version of the original error: "The permissions granted to user 'DESKTOP-7CH23GV\a_c_d' are insufficient for performing this operation. (rsAccessDenied)". One more piece of what I thought could be relevant info: To login to my Windows 10 I was using my Microsoft account (the one associated to my hotmail.com account), and not a local user account. So, I wondered if that modality was causing the problem. So I created a new local user account of type Administrator, and tried again. Same error. So, that is not the culprit. To sum up, the constraints seem to be: OS: Windows 10 Login with MS Account or local user (Both accounts of type Administrator) Sql Server: 2014 Express Browser: Edge (run normally) or Chrome/Firefox (run normally or As Administrator) Wonder if anyone out there has got it to work like that. Thanks.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.