I am a longtime SSRS user/dev and thought I understood SSRS security but...I just installed SSRS 2008 R2 on a new Windows 7 Ultimate laptop and keep getting a "User 'xxx' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed." error when attempting to access Report Manager or deploy a report. I am NOT on a domain. The user account is a member of Adminstrators and has no problem getting into the SQL Server using SSMS. If I log in as the Administrator account, however, I have no problem even though my other account is a member of Administrators. Anyone know what is going on? I have never had this problem with SSRS 2000, 2005, or 2008. Thanks, PaulPaul Litwin

Hi Paul, I had also faced the same issue. I was admin on the box (Win 2008 server) where SSRS 2008 was hosted. I was not able to access the report server when I ran the browser on normal mode. However I was able to access when I ran it as admin. I thought this might be due to UAC. To overcome this I added myself as System Admin in SSRS. Regards Suresh

Hi Paul, Please run Internet Explorer(IE) as Administrator to fix the issue. Yes. This issue is caused by UAC. In Windows 7, IE run under user privileges, which is not enough for accessing Report Server. You could find more information about this issue from: http://msdn.microsoft.com/en-us/library/bb630430.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Hi Jin I also have an issue trying to load the Report Manager after clicking on the URL within Reporting Services Configuration Manager. (http://localhost:8080/Reports). I get the same message that Paul received and I have tried to follow your solution. I get as far as running IE in Administrator mode but do not have a 'Properties' link on the home page of Report Manager. I am using SSRS2008 Express edition. Please note, I am all new to this, so please bear with me. Your assistance would be greatly appreciated. Thanks Dean

Hi Dean, Once you browse to the url as admin, you will see "Site Settings" at the right-hand top corner. Click on it. In the resulting window, click on Security. In the next window, click on "New Role Assignment". Add the id for which you want to give admin access on the report server and select "System Administrator" role. Once this added, you can open the URL in normal mode with this ID and you will be able to add other users. Regards Suresh

Hi Suresh Thanks for coming back to me. Been looking at this today prior to seeing your response. I had to change my 'User Account Control Settings' to 'Never Notify' before I could actually see the Report Manager home page. Now I can see the link for site settings. I did as you suggested and created a new role assignment and added my user profile. Now I have another issue.... From inside Reporting Services Configuration Manager, if I click the URL for either Web Service or Report Manager, the page loads fine. However, if I open up Report Builder 2 and make a slight change to the report and then try and Save As, I get the following.... Connection failed Unable to connect to the server that is specified in the URL, 'http://localhost:8080/Reports' I have double checked the URL and it looks fine. If I actually type it in manually on a webpage, the page loads ok. Therefore, I've come to the conclusion that I must be using some other profile when working within Report Builder, but I'm not sure. Again, yours or anybody elses assistance would be greatly appreciated. Thanks Dean

Hi Dean, The Report Builder 2.0 should connect to 'http://localhost:8080/ReportServer', not 'http://localhost:8080/Reports'. After changing 'http://localhost:8080/Reports' to 'http://localhost:8080/ReportServer', you will be able to save reports to report server. Thanks, Jin ChenJin Chen - MSFT

Hi Jin I can now save my report successfully. Many thanks to you and Suresh for you assistance. thanks Dean

Hi , I am experiencing the same issue with Windows 7 and SSRS 2008 R2 I run IE as Admin , but still receive err msg: "User 'xxx' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed." Any thoughts thanks John

Hi John, Have you checked this link:- http://msdn.microsoft.com/en-us/library/bb630430.aspx You should be able to achieve it. Thanks KumarKG, MCTS

Hi Kumar, I am working for the first time on the SSRS. I have gone through the above link and i configured upto point 12 and then onwards i could not go further as i could not understand. I am sharing information about software that were installed in my laptop. 1. OS# Windows 7 Ultimate(64 bit) 2. SQL Server 2008 R2 (Microsoft SQL Server Enterprise Evaluation Edition(10.50.1617 RTM)) SSMS details are as belowServer Name # SAI-PCConnection # SAI-PC/SAIAuthentication Mode # Windows Authentication 3. Visual Studio 2010 Ultimate I created Simple report and tried to deploy it then i got the below error Error 1 The permissions granted to user 'SAI-PC\SAI' are insufficient for performing this operation. 0 0 I started googoling then i used the report manager link as http://localhost/ReportServer/ I got an error as below The permissions granted to user 'SAI-PC\SAI' are insufficient for performing this operation. (rsAccessDenied) Get Online Help Agian i googled for the information and i tried the below lin Reports Url of my is http://sai-pc/Reports/Pages/Folder.aspx on this url i am getting error as below User 'SAI-PC\SAI' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. if i click on the My Subscriptions then it is navigating to this link http://sai-pc/Reports/Pages/Subscriptions.aspx Kindly help out in resolving this error message. I appericate for the help. Thanks, mrreddy007(M Raghavendra Reddy )

Hi Kumar, I have restarted my laptop and clicked on the link provided in the report manager URL. Then it got opened. I configured the reporting service as described in the link.(http://msdn.microsoft.com/en-us/library/bb630430.aspx) Then i depolyed my report from the BI tool. it was successfully and verified the same in the report manager "Sample report" was present in the folder. IThank all of you for sharing the info. Thanks, mrreddy007(M Raghavendra Reddy)

Hi Kumar, I have restarted my laptop and clicked on the link provided in the report manager URL. Then it got opened. I configured the reporting service as described in the link.(http://msdn.microsoft.com/en-us/library/bb630430.aspx) Then i depolyed my report from the BI tool. it was successfully and verified the same in the report manager "Sample report" was present in the folder. IThank all of you for sharing the info. Thanks, mrreddy007(M Raghavendra Reddy)