Collection 'Script Manager' failed: User 'spotlight service account here' does not have permission (4280524)

Spotlight uses the freeproccache command in two instances:

1. In the Memory / Procedure Cache, Drilldown there is an Action button in the Ribbon, called "Clear Cache".  The hint for this button warns of the performance impact.  If clicked, there is a confirmation dialogue that prompts the user before performing the action.

2. Spotlight uses a lot of dynamic SQL statements. Periodically, we remove these statements from the Procedure cache by scanning the SQL statements looking for "Spotlight.Dont.Cache".  This has proven to be a more effective manner than using the recompile hint.

Run command to grant spotlight user permission.

grant alter server state to "trustedUser";

(src: http://technet.microsoft.com/en-us/library/ms174283.aspx - permissions section)