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.