Asked by:
Principal user is missing prvReadReport privilege.

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.
- Changed type Mandar M Joshi Monday, April 23, 2012 10:13 AM
- Edited by Mandar M Joshi Monday, April 23, 2012 10:14 AM
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 AMAnswerer -
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