CRM dashboard errors 'Execute permission was denied on the object 'RecIDList'

Problem

Loading the CRM Dashboard errors with the following message

Solution

SQL skills are required

Access to SQL Management Studio and the ability to execute scripts are required.

 

In versions 7.02.01 or earlier upgrades or create new database or demo databases did not grant permissions to the SQL user defined type RecIDList.  The work-around for 7.02.01 or earlier is to run this script against the database:

GRANT EXEC ON TYPE::RecIDList TO JiwaUser

Related articles