Link to home
Create AccountLog in
Avatar of winjittechnologies
winjittechnologies

asked on

Error while connecting to SSRS

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.
Avatar of SNilsson
SNilsson
Flag of Sweden image

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

Avatar of winjittechnologies
winjittechnologies

ASKER

But this user have all permission on that machine. It is domain admin user..
What could be problem?
ASKER CERTIFIED SOLUTION
Avatar of SNilsson
SNilsson
Flag of Sweden image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
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.
Did you add the domain user like the picture below shows?
ssrs.png
Now that issue is also resolved.

but getting other issue. please find attached image
error1.JPG
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.