Today we have found a solution for a MS CRM 2011 Bug.
If you select more than 20 records for a report and execute it and this is true for their own reports and standard reports.
A error occurs:
“The SELECT permission was denied on the object ‘fn_GetGuidsFromString’, database ‘MicrosoftCRM_MSCRM’, schema ‘dbo’.”
A Microsoft support professional has recommended the following steps and this has resolved the problem:
- Go to the SQL Server database for CRM in the properties of the Reporting Group and select the area Securables.
- Then check whether the function is included with fn_GetGuidsFromString Grant Select and add if necessary.
We hope it helps.