Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Principal user is missing prvReadReport privilege. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I'm trying to import a solution in CRM 2011 but it fails giving following error.

    Principal user is missing prvReadReport privilege.

    I'm having System Administration and System Customiser Role.

    Can any one help me with it.


    Monday, April 23, 2012 9:54 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    How much organizations exists on your enviroment?

    Monday, April 23, 2012 2:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    HelloMandarM:

    For importing the solution, either you are importing solution for first time in the organization or solution contains some custom plug-ins then user must have to be deployment administrator and db_admin role also.

    Also you should add this user to prvReadReport group in SQL server.

    It will work fine for sure.

    Thanks

    Saurabh Gupta, MS CRM 2011 Software Development Engineer

    Tuesday, May 1, 2012 7:54 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    System Administrator should have Read Privileges to reports.

    Is SRS installed on this? Also can you please provide the crm traces when this error happens?

    Thanks,

    adi.

    Thursday, May 10, 2012 10:54 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Add that System admin user in Deployment Manager as deployment administrator.

    Add that System admin as administator in SQL Server and SQL Reporting Server.

    Check in Domain Controller whether that user having access to following groups

    1. PrivUserGroup

    2. SQLAccessGroup

    3. ReportingGroup

    4. PrivReportingGroup

    Thanks & Regards, MS CRM Consultant, V.Surya.

    Friday, May 11, 2012 9:29 AM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Mandar M Joshi:

    From your statement, what I think the issue is with privileges.  Either the person you are trying to create report do not have proper permission in database or he/ she is not a member of 'PrivReportingGroup' in CRM database.

    You can also refer to this link 

    This link is exact what I want to explain....

    Try to do these actions and let me know....:)

    Saurabh Gupta, MS CRM 2011 Software Development Engineer

    Saturday, May 19, 2012 6:07 PM