EXECUTE permission denied SQL Error (229)

When you see the following error:

System.Application.Exception: The EXECUTE permission was denied on the object 'usp_AFDatabase_insert', database 'PIFD' schema 'dbo'.'.

System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'usp_GetCollection', database 'PIFD', schema 'dbo'. Database role db_AFServer has not been granted permission to execute this stored procedure.

Try the following:

Assign the db_AFServer database role to the PI AF Application Service account.