ERROR: The select permission was denied on the object ‘fn_GetGuidsFromString’, database ‘MicrosoftCRM_MSCRM’, schema ‘dbo’

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.

Markus

 

 

 

 

No comments yet.

Leave a Reply