EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'

I could not find a sub-forum for SQL Server to which this applies, so I would welcome any suggestions as to where to post it.

Here is the problem: I have a VB.Net 2008 solution that sends an XML string to another agency. The data reaches the other agency, but I get the following error message:

System.Web.Services.Protocols.SoapException: Server was unable to process request. --> The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'.

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at CrimNetCLGrandJury.PCSCAgave.GJFeed.Send(String xmlFeed)

at CrimNetCLGrandJury.FeedControl.CreateFeed_Click(Object sender, EventArgs e)

We do not use the sp_send_dbmail stored proc at all.

Thanks!

EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'

You can use google to search for other answers

More Threads