Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > MICROSOFT CRM (TECHNET) > rsAccessDenied Error
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 27th August 02:06
storm
External User
 
Posts: 1
Default rsAccessDenied Error


I am a CRM consultant and I have recently encountered this error at one of my
clients:
---------------------------------------------------------
Details

Product:
SQL Server Reporting Services

Event ID:
rsAccessDenied

Source:

Microsoft.ReportingServices.Diagnostics.Utilities. ErrorStrings.resources.Strings

Version:
8.00

Message:
The permissions granted to user '{0}' are insufficient for performing this
operation.

Explanation

Before an operation can be performed, the report server checks whether the
user requesting the operation has permissions to perform the operation. In
Reporting Services, permissions are rolled up into tasks. Access to an item
is based on role assignments that include or exclude tasks for the user. The
rsAccessDenied error occurs when the user or application attempts an
operation that is not supported by the role assigned to the user or
application.

If you are using the default role assignments that install with Reporting
Services, access is defined only for the local administrators group.
Additional role assignments must be made to provide access to other users.

User Action

Review the role assignments for your report server. For example, to give
users permissions to browse and view reports, assign them the Browser role,
which by default includes tasks to manage individual subscriptions and to
view reports, folders, and resources. For more information about assigning
roles and updating report server security, see Books Online.

If you have assigned the appropriate roles to the user and the error still
occurs, make sure that anonymous access is disabled in IIS for the report
server and Report Manager virtual roots.


--------------------------------------------------

I have gone to a point of uninstalling and re-installing CRM 3.0, and even
granting the users the same access right as the administrator; but this does
not work. The problem is encountered when the users try to view reports.
Momentarily only the systems administrator is able to view them.

Can anyone assist me?


--
STORM
  Reply With Quote


  sponsored links


2 27th August 02:09
laurie heer
External User
 
Posts: 1
Default rsAccessDenied Error


Assuming that you checked all the things suggested by the error.... Is the
user a member of the PrivlegedUserGroup created by CRM during the install??
This would also cause the problem.
  Reply With Quote
3 27th August 02:10
storm
External User
 
Posts: 1
Default rsAccessDenied Error


Hi Laurie

The users are part of the PrivUserGroup. They are accessing the reports
directly through the reporting services and not necessarily through the CRM
application.


--
STORM
  Reply With Quote
4 27th August 02:10
laurie heer
External User
 
Posts: 1
Default rsAccessDenied Error


What is your server configuration? If you have CRM, SQL, and SQL Reporting
Services on the same system you should not have a problem. This would be
especially true if you let CRM install Reporting Services for you.

If you have some other configuration, see Microsoft CRM 3.0: Additional
Setup Tasks Required if Reporting Services Is Installed on Different Server
(http://go.microsoft.com/fwlink/?LinkId=57772).

"because some reporting tasks are processed by Microsoft CRM, some by
Reporting Services, and some by Microsoft SQL Server, when Reporting Services
is on a different computer than either the Microsoft CRM server or the server
running Microsoft SQL Server, a second authentication must occur. This second
authentication is done by the service on the middle computer that is
impersonating the end-user to the service on the third computer. This is
called double-hop Kerberos authentication."
  Reply With Quote
5 27th August 02:11
storm
External User
 
Posts: 1
Default rsAccessDenied Error


Hi Laurie

SQL Server is on the same server as the Reporting Service, while CRM 3.0 is
on it's own server. There is a trust delegation (as suggested in the do***ent
link you gave me). The administrator can access the reports; the users are
unable to do so. There is no host header that has been setup.

What has been suggested in the do***ent, is not to be working.


--
STORM
  Reply With Quote
6 27th August 09:52
laurie heer
External User
 
Posts: 1
Default rsAccessDenied Error


Mmmm...

Could it be a SQL Server security issue instead of a CRM Security issue?
Check your SQL logins and make sure the businessunit/ReportingGroup {blah
blah} is there and that it has access to the crm database (metabase doesn't
have to be checked). There is usually a second one as well that gives public
access.

After that, I'm running a little short on ideas...
  Reply With Quote
7 20th September 13:46
ian sir&
External User
 
Posts: 1
Default rsAccessDenied Error


Have you check the Security Roles/Privilege you've given to the users
accessing it?

In your reports, typically we use the Filtered view right? Within these
view, it takes into account the roles and privileges set to the accessing
user. This way, depending on the privileges of the user, it only gets the
"filtered" information.

Maybe the user is opening a report that accesses entities that the users
doesn't have privilege on.

HTH
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666