rsAccessDenied (RESOLVED) - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

rsAccessDenied (RESOLVED)

Author

Topic

Pace
Constraint Violating Yak Guru

264 Posts

Posted - 2007-07-12 : 07:35:04

Hi,

I have installed SSRS and created a .net application... now when I try to open the report viewer, I get the error " the permission granted to user 'domain\user' are insufficient for performing this operation. (rsAccessDenied)" I have searched the net hi and low and cant seem to find an adequate answer... something to do with roles or permissions? I have assigned permissions to this user on the ssrs database, yet I still cant seem to view the report. It works fine in my test environment (as it usually does

) any help on this would be greatly appreciated as to be honest, I dont really know what im doing here.

"Impossible is Nothing"

Pace
Constraint Violating Yak Guru

264 Posts

Posted - 2007-07-13 : 04:42:10

was having a nightmare working late on this one.

I eventually found out that you can access the server that runs ssrs to manage it. Now I was by mind defualt (

) going to http://serverName-InstanceName/ReportsServer and yes I could see the files, but if you head to http://serverName-InstanceName/Reports you get a whole different kettle of fish... mainly options! :-)

Now I just had to choose "Properties" and I could see that users with rights were "Built-In\Administrators" so I simply added my windows group with "browse" rights and that seemed to authenticate the users.

What I also had to do as in the great scheme of changing things like a mad man, was go in and delete all my folders where the reports and datasources were, as I was getting conflicting errors. Once I had cleared these, I re-published my report project and viola! Works a treat. phew, what a lesson in ssrs, happy though as I actually fixed it once yesterday changing service settings, it eventually worked, though I was unhappy at the fact I diddnt understand and broke it again. Started from scratch and worked out the above, much happier now because I underastand more than anything.

Hope this helps someone else

"Impossible is Nothing"

bb2003
Starting Member

6 Posts

Posted - 2007-07-17 : 17:03:05

Hi,

We installed SQL Server 2005 on windows 2000 with IIS 5. After installation, I can see report manager using http://localhost/reports. But I can only the top part. There's no My Reports or anything, just "Home / My subscriptions / Help".

Is there anything wrong and how to fix it?

Any help would be appreciated.

Thanks

Maxer
Yak Posting Veteran

51 Posts

Posted - 2007-07-30 : 16:54:07

Sounds like you don't have sufficient access rights to the server.

Try looking at it with an Admin account just to be sure, then using SSMS login to your server's reporting services and dole out some permissions for your user account

bb2003
Starting Member

6 Posts

Posted - 2007-07-31 : 12:13:41

Thanks for your response! I used admin account. I have no problem to log into data engin, but failed on report engin.

I posted a new topic, and here is the detail:
We installed SQL Server 2005 on windows 2000 with IIS 5. After installation, I can see report manager using http://localhost/reports. But I can only the top part. There's no My Reports or anything, just "Home / My subscriptions / Help".

Do you think it is because of on Windows 2000 with IIS5?

nitins
Starting Member

2 Posts

Posted - 2007-08-16 : 08:18:10

Hi,

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

quote:
Originally posted by Pace

was having a nightmare working late on this one.

I eventually found out that you can access the server that runs ssrs to manage it. Now I was by mind defualt () going to http://serverName-InstanceName/ReportsServer and yes I could see the files, but if you head to http://serverName-InstanceName/Reports you get a whole different kettle of fish... mainly options! :-)

Now I just had to choose "Properties" and I could see that users with rights were "Built-In\Administrators" so I simply added my windows group with "browse" rights and that seemed to authenticate the users.

What I also had to do as in the great scheme of changing things like a mad man, was go in and delete all my folders where the reports and datasources were, as I was getting conflicting errors. Once I had cleared these, I re-published my report project and viola! Works a treat. phew, what a lesson in ssrs, happy though as I actually fixed it once yesterday changing service settings, it eventually worked, though I was unhappy at the fact I diddnt understand and broke it again. Started from scratch and worked out the above, much happier now because I underastand more than anything.

Hope this helps someone else

"Impossible is Nothing"

nitins
Starting Member

2 Posts

Posted - 2007-08-16 : 08:18:42

quote:
Originally posted by Pace

was having a nightmare working late on this one.

I eventually found out that you can access the server that runs ssrs to manage it. Now I was by mind defualt () going to http://serverName-InstanceName/ReportsServer and yes I could see the files, but if you head to http://serverName-InstanceName/Reports you get a whole different kettle of fish... mainly options! :-)

Now I just had to choose "Properties" and I could see that users with rights were "Built-In\Administrators" so I simply added my windows group with "browse" rights and that seemed to authenticate the users.

What I also had to do as in the great scheme of changing things like a mad man, was go in and delete all my folders where the reports and datasources were, as I was getting conflicting errors. Once I had cleared these, I re-published my report project and viola! Works a treat. phew, what a lesson in ssrs, happy though as I actually fixed it once yesterday changing service settings, it eventually worked, though I was unhappy at the fact I diddnt understand and broke it again. Started from scratch and worked out the above, much happier now because I underastand more than anything.

Hope this helps someone else

"Impossible is Nothing"

jtdesa
Starting Member

1 Post

Posted - 2008-11-14 : 12:58:19

I Had the Same Error When I Went on posting Web Application on my production Server, and i've basically tried Almost Everything in This Threads.

And Solution was very Simple!

I Had a couple Of ReportViewer Controls on my page, and they All had their "ReportServerUrl" on the markup binded to my machine name like "http://<MyComputerName>/ReportServer"

So I Did it on my .ascx.cs side, on my code i dynamically changed that attribute to "http://localhost/ReportServer".

Or

You could Just in Markup set that same attribute with :

"http://<MyComputerName>/ReportServer"

And it will have the same effect.

Remember though its no any Engenious Solution, I posted Here Because that was the problem in my case, and probably some of you ...
or anyone passing this same thread in the future, could stumble uppon
this same issue

Cheers.

trevors99
Starting Member

1 Post

Posted - 2008-12-02 : 06:31:25

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 :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources