Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.
Course Of The Month
7 days, 15 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Error while connecting to SSRS
Posted on 2009-05-04
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.
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
4
8 Comments
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
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
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.
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.
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.
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.
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.
Good that the access problem is solved then.
Please look at http://www.experts-exchange.com/Database/Reporting_/Q_24378489.html this issue as well
Featured Post
Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month7 days, 15 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
617 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.