Bill Jones Jr. MVP Visual Basic

Bill,
Your post on Authentication was a big help in resolving the same problem at my client site. Thanks a bunch.
Sanjay

Glad I could help.

I salute the King.

Thank You, really helped

Enjoyable Narrative

You are most welcome Ernest B.

Bill J

Doesn't work in my case (Windows 2003 Server, SQL 2000 SP3a, RS 2000 SP2) still rsAccessDenied.

Thanks. It solved my problem too. It would solved it more quickly if I read it more thoroughly. I get so used to skimming

hey that gave me high fives from the customer
but iwas for u

YES!...THANK YOU, BILL!!!

Bill Rocks...if you deny it, you're a terrorist..

Thanks again!

Russ

Thanks from Russia

You really help me, thanks from Rome (Italy)

Thank You, really helped

Thanks for the post, it works well, however how to assign the roles if I need anonymous access (without enabling it on IIS and SQL RS)??? from the report manager that is.

dear Bill,

I tried follow the steps you had mentioed but it doesnt seem to be working. I might be going wrong somewhere. Could you please let me know the exact steps (also from where to do those like, through Reporting Services Manger ) to follow ?

This would be of great help

Best Wishes
Nitin S

The permissions granted to user 'SHAWAHNEH\ASPNET' are insufficient for performing this operation. (rsAccessDenied)

So PLZ I want to solve this Problem.

Awesome tip Bill. Worked like a charm for me!

Not only that but check out how wicked this combination is.

Try the same thing that you tried above, but do it with and without "Anonymous Access" setup for the ReportServer virtual directory.

If "Anonymous Access" = OFF then you get the ability to edit those roles that you listed (Guests and Users with SRS Browser capacity)

If "Anonymous Access" = ON then you don't get anything. Kaput. Nothing but a blank properties screen.

Talk about 'needle in a haystack'. Crazy.

I had a hard time getting it to work, was getting a blank page when I launched the Report manager (htto;//localhost/reports), but here's what got me going:

Launched IIS, under Default Website go to Reports node and opened up security settings. Disabled all authentications (especially Anonymous and Windows) and enabled only Basic and ASP>NET impersonation. Next time I opened Report Manager it asked for my credentials and there it was... the report manager in all its glory..

just did high fives in air as I was the only one working in the office on this Friday afternoon.

eJazz

Was getting rsAccessDenied for the _IUSR account. Turns out if Anonymous Access is turned on, IIS grabs that first and never authenticates. So even if you are logged on as an Administrator you can't access the Home folder in SQL Manager for Reporting Services. Removing Anonymous Access with the IIS virtual directory (thanks Robert Naum above) allows you to access...

"If this stuff was easy, nobody would need developers"

There's a reason I'm losing my hair and sanity!

LOL!! Big up !


:D

Okay... that was simple! (Sigh)

Thanks, you've saved me a lot hassle! :-)

It sounds from the dialog here that everyone is running Sql Server 2005 and IIS 6. I'm running Sql Server 2008 CTP and IIS 7 (Vista Ultimate). I don't see where I have the setting available for "Anonymous User." I get just a header on the /reports. I've tried, everything I can think of.

Also, in the Sql Server Management Studio my folders look different - no HOME area, just JOBS.

Man, I hope you can help me...

Um, I found the Anonymous User setting, but that didn't help.

When I first installed Sql Server, apparently my Default Website was not running, so I thought it might be a bad install. At any rate, I gave Everyone all rights to the physical folders, but I still got the error. So I just installed a new instance - but still I get the access denied. Maybe I don't quite get the solution you are describing?

>>>...Hmmm. At the Home folder level, I could add roles....

At the Home folder level I can do NOTHING. What do I do in this case?

I have the same problem of this access denied...
I am runing Vista buzisness and SQL server 2005.
In order to make it work i need to run my exporer with administrative rights , then i can get my reports but could not find the way of running it as a normal users in order to simply browse to my report page...
I have check many thing as well as the step by step procedure to setup SQL 2005 under vista but othing works...

any idea?

Hi William,

I am using SQL 2008 RTM on Vista x64. I have experienced the same issue with yours. I had solved my issue.
Initially I use a user account with local admin rights to start SSRS services. It started well, but when I go to Report Manager URL. I got rsAccessDenied error. This is similar issue with what I used to have in SSRS 2005 when I changed services account to a normal user rather than "Network Service".
So to solve the issue, what I did is:
- change the services account back to "NetworkService" built-in account via SSRS Configuration Manager
- restart my computer.
- voila, it works!!

HTH,
Uzzi

Thanks Bill, from sunny Los Angeles!

Tnx, Bill. Great advise.

Thanks so much form venezuela! this solution made my day

Bill, you are the greatest. I have tried so hard, just aboth to give up; then i saw your article. Oh man, i feel good, really good. Keep doing what you are doing.

THANKS out loud!

Really helped, thanks from Lithuania

Well all of that didn't work for me. I am running SQL 2008 on Windows Server 2008.

It worked after I set the site to TRUSTED for the reporting services site.

You are a star... thanks

hi there,

I hope that my short explaination about setting up SSRS 2008 will help you guys out there. The usual error that faces the SSRS 2008 installer is that you sometimes can get this error: "The permissions granted to user 'username' are insufficient for performing this operation. (rsAccessDenied)"

this is what my current host (www.asphostcentral.com) did to install the Reporting Service 2008 for me.

1. They asked me to provide a Report Server and Report Manager URL, e.g. www.myDomain.com/RS for Report Server and www.myDomain.com/RM for report Manager
2. They begin to install the SSRS 2008 by specifying the above URL on the Web Service URL and Report Maanger URL
3. They did create the Report Server Manager database for me
4. Under the Service Account, they use my FTP details as the login details
5. Once this is done, they created a user called "my_FTP_Username" on the Report Manager interface and assign the role: BROWSER and PUBLISHER for me.

They then came back to me and informed that everything is up and running. I tested it out and yes, it was working perfectly. The MOST common issues that I can see is that usually you guys fails to assign the correct role to the FTP User. If you have an FTP User called: "abc" then, the BROWSER and PUBLISHER roles must be assigned to "abc" user.

With just $4.99/month, I strongly believe that asphostcentral.com is worth a try. They did charge some fees for SSRS 2008, but it certainly recommended as there is no headache whatsover :)

I am a happy camper with them :)

P.S: I have not tried SSRS 2005. I jumped straight to use SSRS 2008 because I want new technology on my portal and I strongly believe that the setup of SSRS 2005 will be less about the same with the SSRS 2008.

P.S2: If you are setting the SSRS on your LOCAL PC, that would be even easier. Why? Just assign your SSRS user an Administrator rights and everything will be working fine. If you do not know how to add your user as an Administrator, please go to your "Computer Management" and add the user under the "Administrator" groups. Fixed all :)

hi Trevor_Bonny,

I am new to SQL server and its configuration .
I am facing a same problem while doing a project
can u guys please help me out by explaining how to add roles
and adding Users with SRS Browser capacity

To all those who still face the issues in SS2008 with Vista please follow the below link.
http://www.sqljunkies.com/Article/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
You need to have a virtual directory for Report Server and Reports pointing to your respective directories. (The default locations are "C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer" and "C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager" respectively)
Once you do that you will have the Contents and Properties available in the Home page.

To create User Roles Go to Properties tab, click on New Role Assignment. Create the user and assign the roles.
For existing User Roles, you may click on the Edit Roles and and assign the roles.

Error
deploy to server

The permissions granted to user 'ACP06\IUSR_BUNNYXPC' are insufficient for performing this operation

Works for me, nice to see a bit of narrative bundled with a solution to a real problem!

Thanks Bill, from Mexico!

Bill - Thank you, Thank you, Thank you. after two days of tearing my hair out and Google searching I finally came upon your site and this solved a this problem of mine that stumped two of my developers.

I'm not sure if this is exactly the same issue, but it's similar When we add a new user to the Active Directory group, that has permissions to view the report, they can access all sharepoint content, and web parts, except reports...they get the rsAccessDenied....It's a transient problem...gone in 2 days. We're using windows integrated security, and SP integrated mode for RS. Any ideas?

I had the same error - completely stumped, local admin, admin rights on the db etc etc.
Turned out, as I was opening the page locally on my server, I had to right click and choose "Run As Administrator."
No doubt I am the only one daft enough to have that problem, haha.