Error: The EXECUTE permission was denied on the object USP_LOAD_EXTERNALSERVICECONFIGURATION - on testconfig for BBNC service db connection

The following error may appear on the test config for the BBNC service db connection line:

System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'USP_LOAD_EXTERNALSERVICECONFIGURATION', database '5740PB01_3a16ab4d-744b-4a5b-bb69-aa63c8b1c0e7', schema 'dbo'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Blackbaud.AppFx.EmailServices.Catalog.SPWrapEmailServices.USP_LOAD_EXTERNALSERVICECONFIGURATION.WrapperRoutines.ExecuteNonQuery(SqlConnection conn, Nullable`1& DATALOADED, Nullable`1& TSLONG, String& HOST, String& USER, String& PASS, String& USESECURE, String& TRANSACTIONALPATH, String& GENERALPURPOSEPATH, String& STATUSPATH, String& BINDING, String& USESHAREDSERVICESCOMMSERVICE, Int32& returnIntValue, Int32 timeout, SqlTransaction tran)
at Blackbaud.Web.Content.Core.PingExternalService.LoadSettings()
at Blackbaud.Web.Content.Core.PingExternalService.PingExternalServices()
at Blackbaud.Web.Content.Core.Settings.GetBBBCSService()
at Blackbaud.Web.Content.Core.ConfigurationValidator.BBCSServiceConnection()
ClientConnectionId:ecf1cd13-864d-4e9d-9dc2-f5efd6797c92
Error Number:229,State:5,Class:14
Please chat with support with the following information:   
  • The exact steps to duplicate the issue (click by click).
  • This article number.

Environment

 Altru Arts & Cultural

Was this article helpful?