locked
Principal user is missing prvReadReport privilege. RRS feed

  • Question

  • 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

  • Hi,

    How much organizations exists on your enviroment?

    Monday, April 23, 2012 2:12 PM
  • 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
  • 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
  • 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
  • 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