Solved

Error while connecting to SSRS

Posted on 2009-05-04
8
467 Views
Last Modified: 2012-05-06
Hello,

I am getting following error while connecting to SSRS using application written in VS 2008.

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

Same error I am getting while connecting using browser (IE). But when I run IE in admin role then I can access it.
One more thing my user which I am using to connect is 'admin user'. So it has full access.

Can anyone help me? Its urgent.
0
Comment
Question by:winjittechnologies
  • 4
  • 4
8 Comments
 
LVL 8

Expert Comment

by:SNilsson
ID: 24293956
You need to add the user in report manager and set what permissions he should have:
Permissions:
http://msdn.microsoft.com/en-us/library/aa337491.aspx

From Msdn:
Permission to access report server content and operations are granted through role assignments. On a new installation, only local administrators have access to a report server. To grant access to other users, a local administrator must create a role assignment that specifies a domain user or group account, one or more roles that define the tasks the user can perform, and a scope (usually the Home folder or root node of the report server folder hierarchy). You can use Report Manager to create the role assignments.
http://msdn.microsoft.com/en-us/library/aa337279.aspx

0
 
LVL 1

Author Comment

by:winjittechnologies
ID: 24294046
But this user have all permission on that machine. It is domain admin user..
What could be problem?
0
 
LVL 8

Accepted Solution

by:
SNilsson earned 500 total points
ID: 24294194
It needs to have correct permissions on ssrs/sql server also, try adding the domain user like this:

1.If necessary, log on as a local administrator.

2.Open a browser window and type the Report Manager URL to start the application.

3.Click Site Settings at the top of the page.

4.Click the Security tab at the side of the page. This page shows all system-level role assignments that are currently defined. On a new report server installation, only the two predefined roles, System Administrator and System User, are visible. There is one built-in role assignment that is created automatically; it maps the built-in local administrators group to the System Administrator role

5.Click New Role Assignment.

6.In Group or user name, specify a domain group account that includes all of the users who require permissions to view report server content and subscribe to reports. Specify the account in this format: domain\group. The account should be in the same domain or in a trusted domain. If you do not have a domain group that fits this description, you can specify individual domain user accounts instead.

7.Select System User.

8.Click OK.

Click New Role Assignment again.

In Group or user name, type the name of a domain user account for a user who has administrative responsibilities for this report server. Specify the account in this format: domain\user. The account should be in the same domain as the report server or in a trusted domain.

Click OK.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:winjittechnologies
ID: 24294747
Thanks a lot ..
That issue is not there but now we are facing some other isssue

Logon failed. (rsLogonFailed)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

but credentials are ok.
0
 
LVL 8

Expert Comment

by:SNilsson
ID: 24295223
Did you add the domain user like the picture below shows?
ssrs.png
0
 
LVL 1

Author Comment

by:winjittechnologies
ID: 24295355
Now that issue is also resolved.

but getting other issue. please find attached image
error1.JPG
0
 
LVL 8

Expert Comment

by:SNilsson
ID: 24295527
That seems to be a IIS problem with the web site INSIMPADMIN, check the iis if the web app is ok.

Good that the access problem is solved then.
0
 
LVL 1

Author Comment

by:winjittechnologies
ID: 24296815
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question