search cancel

Error running the API Account Utility

book

Article ID: 229952

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

The following error is returned when running the APIAccountUtility executable to generate API keys per the instructions provided in the Using REST API with Symantec ICA section of the Symantec Information Centric Analytics (ICA) Administrator Guide:

ERROR:The EXECUTE permission was denied on the object 'spPortalSettingsGetAll', database 'RiskFabric', schema 'dbo'.

Environment

Release : 6.5.4

Component : API Account Utility

Cause

The user account under which the APIAccountUtility was run does not have the correct role or privileges assigned on the SQL Server hosting the RiskFabric database to execute stored procedures.

Resolution

Run cmd.exe under the ICA service account credentials, or as any other user that has been assigned the sysadmin role on the SQL Server hosting the RiskFabric database.