Answered by:
User does not have required permissions.

Question
-
I cannot access either the web service url or the report manager url unless I have switched off UAC and rebooted. I have read a bundle of threads on this and tried most of the sensible suggestions. Running IE as administrator makes no difference and setting up a role for my specific account makes no difference. My account is already an admin account and is the account I used to install. I am experiencing these symptoms on two separate (Windows 7 Ultimate) machines with SQL 2008 R2 SP2 Developer edition.
The error message I get is
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.
I don't want to leave UAC permanently switched off. Does anyone have any suggestions please? Thanks.
Thursday, October 24, 2013 11:30 AM
Answers
-
Hi Justnod,
In you scenario, to avoid this issue, you can add the Report Server URL and Report Manager URL to trusted sites. Please refer to the link below to see the detail steps about how to add it to trusted sites.
How to: Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008 (UAC)Hope this helps.
Regards,
Charlie LiaoIf you have any feedback on our support, please click here.
- Proposed as answer by Charlie Liao Thursday, October 31, 2013 2:34 PM
- Marked as answer by JustNod Thursday, November 7, 2013 1:21 PM
Friday, October 25, 2013 9:42 AM -
I have got this to work now, thank you very much. I'd missed out one of the steps on my first attempt. I don't know if you're aware but the link you supplied did not work. I assume that it was meant to point to:
http://msdn.microsoft.com/en-us/library/bb630430%28v=sql.105%29.aspx
I confess being a bit confused as to why this is necessary and whether everyone would have to complete these unintuitive steps to get access to the URLs. Any scenario where you have to grant permissions to yourself - the user who installed the service - seems very peculiar and unnecessary to me. Thanks again.
- Marked as answer by Charlie Liao Thursday, November 7, 2013 3:24 PM
Thursday, November 7, 2013 1:20 PM
All replies
-
Hi Justnod,
In you scenario, to avoid this issue, you can add the Report Server URL and Report Manager URL to trusted sites. Please refer to the link below to see the detail steps about how to add it to trusted sites.
How to: Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008 (UAC)Hope this helps.
Regards,
Charlie LiaoIf you have any feedback on our support, please click here.
- Proposed as answer by Charlie Liao Thursday, October 31, 2013 2:34 PM
- Marked as answer by JustNod Thursday, November 7, 2013 1:21 PM
Friday, October 25, 2013 9:42 AM -
Thanks for the reply. I did try this briefly and had no success. I will try to give it some more time next week.Friday, November 1, 2013 3:30 PM
-
I have got this to work now, thank you very much. I'd missed out one of the steps on my first attempt. I don't know if you're aware but the link you supplied did not work. I assume that it was meant to point to:
http://msdn.microsoft.com/en-us/library/bb630430%28v=sql.105%29.aspx
I confess being a bit confused as to why this is necessary and whether everyone would have to complete these unintuitive steps to get access to the URLs. Any scenario where you have to grant permissions to yourself - the user who installed the service - seems very peculiar and unnecessary to me. Thanks again.
- Marked as answer by Charlie Liao Thursday, November 7, 2013 3:24 PM
Thursday, November 7, 2013 1:20 PM