I've read through a lot of posts regarding the problem, but none of the proposed solutions have worked for me. I continue to get an error stating, "The permissions granted to user '<servername>\Rich' are insufficient for performing this operation. (rsAccessDenied)." If I am logged in as the local administrator account, entering the Reporting Services URL in IE doesn't give me that error, but it takes me to a blank page. I haven't been able to get to a SSRS home page at all. Order of operations: I installed and patched Windows 7 Ultimate 64-bit I installed SQL Server Express 2008 with Advanced Services using the MS web installer. I downloaded and installed SP1 for SQL Server Express 2008. Opened up an instance of IE and tried to go to http://<servername>/Reports, receiving the above error. Well, technically I first tried /ReportServer_SQLExpress as reflected in the SSRS configuration manager, but that didn't work, either. I then changed the Web Service URL to use the virtual directory, "Reports" instead of the longer ReportServer_SQLExpress. It didn't work either way. I've tried running IE as administrator, adding local machine to trusted sites, and just about every other suggestion I've found. I even ran the entire installation logged in as the local administrator. Nothing seems to work. Could someone please tell me, considering the above installation process, what I should expect to have to do after installation to make this work?

Hi Richard,Generally, the error "The permissions granted to user '<servername>\Rich' are insufficient for performing this operation. (rsAccessDenied)" should be caused by one of the following cases:1. The user "<servername>\Rich" has insufficient permissions to access the report server.2. User Access Control. Windows Vista, Windows 6 and Windows Server 2008 limit the overuse of elevated permissions by removing administrator permissions when accessing applications. Because the operating system removes permissions, members of the local Administrators group run most applications as if they using the Standard User account.In order to fix the issue, please follow these steps:1. Open SQL Server Reporting Services Configuration Manager.2. Connect to instance "SQLEXPRESS"3. Go to "Report Manager URL", make sure what the URL is. e.g. http://<server>/reports_sqlexpress 4. Now, open SQL Server Manager Studio.5. Connect to Reporting Services. Server: .\SQLEXPRESS6. Expand "Security" >> "System Roles" 7. Double-click "System Administrator"8. Select all tasks from the tasks list.9. Click "OK" to apply.10. Now, run Internet Explorer as administrator. Open this link we got in step3.11. We should be able to access the Report Manager now. If we are still not able to access the Report Manager, please make sure the user "<servername>\Rich" is in the local administrator group(By default, only BuiltIn\Administrators will be added to Reporting Serivces, and be assigned as System Administrator).For more information, please see:How to: Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008: http://msdn.microsoft.com/en-us/library/bb630430.aspxIf you have any more questions, please feel free to ask.Thanks,Jin ChenJin Chen - MSFT

Hi Richard,Generally, the error "The permissions granted to user '<servername>\Rich' are insufficient for performing this operation. (rsAccessDenied)" should be caused by one of the following cases:1. The user "<servername>\Rich" has insufficient permissions to access the report server.2. User Access Control. Windows Vista, Windows 6 and Windows Server 2008 limit the overuse of elevated permissions by removing administrator permissions when accessing applications. Because the operating system removes permissions, members of the local Administrators group run most applications as if they using the Standard User account.In order to fix the issue, please follow these steps:1. Open SQL Server Reporting Services Configuration Manager.2. Connect to instance "SQLEXPRESS"3. Go to "Report Manager URL", make sure what the URL is. e.g. http://<server>/reports_sqlexpress 4. Now, open SQL Server Manager Studio.5. Connect to Reporting Services. Server: .\SQLEXPRESS6. Expand "Security" >> "System Roles" 7. Double-click "System Administrator"8. Select all tasks from the tasks list.9. Click "OK" to apply.10. Now, run Internet Explorer as administrator. Open this link we got in step3.11. We should be able to access the Report Manager now. If we are still not able to access the Report Manager, please make sure the user "<servername>\Rich" is in the local administrator group(By default, only BuiltIn\Administrators will be added to Reporting Serivces, and be assigned as System Administrator).For more information, please see:How to: Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008: http://msdn.microsoft.com/en-us/library/bb630430.aspxIf you have any more questions, please feel free to ask.Thanks,Jin ChenJin Chen - MSFT

Hi Richard,Generally, the error "The permissions granted to user '<servername>\Rich' are insufficient for performing this operation. (rsAccessDenied)" should be caused by one of the following cases:1. The user "<servername>\Rich" has insufficient permissions to access the report server.2. User Access Control. Windows Vista, Windows 6 and Windows Server 2008 limit the overuse of elevated permissions by removing administrator permissions when accessing applications. Because the operating system removes permissions, members of the local Administrators group run most applications as if they using the Standard User account.In order to fix the issue, please follow these steps:1. Open SQL Server Reporting Services Configuration Manager.2. Connect to instance "SQLEXPRESS"3. Go to "Report Manager URL", make sure what the URL is. e.g. http://<server>/reports_sqlexpress 4. Now, open SQL Server Manager Studio.5. Connect to Reporting Services. Server: .\SQLEXPRESS Aha! This is probably wherein the problem lies. When I open SSMS, my only connection options are "Database Engine" and "SQL Server Compact Edition". I do not see a "Reporting Services" option in the list. Just to confirm, I *did* install SQL Server Express 2008 with Advanced Services, so I should expect to see "Reporting Services" in that list, correct? I can connect to the local instance of SQL Server and I do see the two Reporting Services databases there......hmm...re-reading your response, perhaps that's exactly what you meant. View the system roles in the Reporting Services database (having connected to the local server "Database Engine"). That could be what tripped me up when I stumbled upon that solution before. Does that sound right? If so, I'll give that a shot.Thanks!Rich

Nope. Added my Windows user account to the dbo role for both Reporting Services databases, and there is no change. Did I misunderstand your suggestion?

Hi Richard, I meant connecting to Reporting Service, not connecting to database and then add a database role. If you have installed SQL Server Manager Studio in another machine, could you please try to connect to Reporting Services from this machine? Besides, please make sure the user you login the server is a local admin. By default, only the Built-in administrators is set as System Administrator once the Reporting Services is initiating. Thanks, Jin ChenJin Chen - MSFT

Hi Richard, I meant connecting to Reporting Service, not connecting to database and then add a database role. If you have installed SQL Server Manager Studio in another machine, could you please try to connect to Reporting Services from this machine? Besides, please make sure the user you login the server is a local admin. By default, only the Built-in administrators is set as System Administrator once the Reporting Services is initiating. Thanks, Jin ChenJin Chen - MSFT

When I start up SQL Management Studio, I am not offered the option of connecting to a Reporting Services instance, only Database Engine or SQL Server Compact Edition. I most certainly *did* install the SQL Server Express 2008 with Advanced Services, so what could be missing?

Hello Richard, Follow these steps to get rid of this error Go to http://Servername/Reports/Pages/Folder.aspx Click on Properties tab Go in Security Click on Add New Role Assignment Enter Group or user name i.e. Domain Name\Username Select Content Manager Role Press OK After this, you should be able to get rid of this error. Please Mark as Answer If it Helps

Hi, I don't know if the OP solved his issue or not, but I had the same problem and after banging my head against my desk for two days thought I would share what worked for me. One caveat - I did try a number of things before hitting on what worked for me, and there may be something else I did along the way that was also necessary (though not sufficient). I did not make any registry or direct .config changes: System setup: Windows 7 64-bit Home Premium; AMD processor; SQL Server Express 2008 R2; just running this stuff on my machine for development purposes. Symptoms: Could not get the URLs in Report Services Configuration Manager to work, even though it was all working fine on a Vista system I set up a few months ago. I have administrator priveleges. I tried opening IE as administrator, authorizing my login in various ways through the configuration manager but just could not get in. It is not possible, btw, to manage the report server grough SSMS in the Express version. You need to find a way into Report Manager with the URL. Crux/Solution: Basically, my administrator account was not THE administrator account for the computer; THE administrator (which is hidden) is different than having administrator rights. So the following steps worked to fix the issue for me: I authorized the "hidden Administrator" account. In Home Premium edition I did this by opening a command prompt "as administrator" and entering net user administrator /active:yes From what I've read, this can be done through control panel with higher versions of Windows 7. Log off and voila there is another user now besides yourself. Logon now as Administrator Open IE "as administrator" and go to http://servername/Reports_SQLEXPRESS url. I was able to log in at this point. Once in Report Manager, I authorized my regular Windows account with all priveleges. I did this in two locations - maybe someone can explain the difference between the two. Click upper right for "Site Settings"; "Security"; Add yourself as New Role as a Site Administrator - you can do this following the steps outlined in reply Jin Chen above. I also found I needed to go back to "Home"; "Folder Settings"; Add yourself as New Role with Content Manager as outlined above by MustafaH. Apply, save, etc.; log out; go back to your regular logon; open IE "as administrator" (not sure if that's necessary but I did it anyway) and go to the URL, log on with your id, saving credentials. You now can get into Report Manager just opening IE and going to the URL's; Deployment from Bus Intelligence Studio works now too. Good luck!!

Hi, this worked for me with Windows 7 Ultimate and MSSQL 2008 R2. Thanks dana_working

While turning the time back (I'm using a VM) I give it another try. In my case it worked as well without using the administrator-account. Just start IE with your normal account (which as the main-user is an administrator) "as administrator" and I was able to use the ReportingService and change the privileges for my account. Without changing the privileges: starting the IE not as administrators show the same error-message as before. HTH

Thanks dana_working. My solution was your step 3. Run IE "as administrator". Windows 7 x64 with SQL Server 2008 R2 (with UAC enabled; I think the problem lies in the UAC).

work for me ------------ thanks this guy ------------- http://www.gotknowhow.com/articles/reportserver-permissions-granted-are-insufficient-for-performing-this-operation-rsaccessdenied