Customers inquire on how to manually grant a sql server account used by spotight to monitor an instance and avoid receiving access denied error messages.
The permissions granted to user are insufficient for performing this operation.
SOLUTION:
Run the grant script on each instance that spotlight will be monitoring, replacing the "trusteduser" with the sql credential receiving the access denied message.
