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

Problem

Loading the CRM Dashboard errors with the following message

Open

Solution

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