Skip to end of metadata
Go to start of metadata

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.01.00 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.01.00 or earlier is to run this script against the database:

GRANT EXEC ON TYPE::RecIDList TO JiwaUser