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

i not find sub-forum sql server applies, welcome suggestions post it.

here problem: have vb.net 2008 solution sends xml string agency. data reaches other agency, following error message:

system.web.services.protocols.soapexception: server unable process request. --> execute permission denied on 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 not use sp_send_dbmail stored proc @ all.

thanks!

hi joe,

please read article solution

http://msdn.microsoft.com/en-us/library/ms188719.aspx

---

arunraj chandrasekaran, mcts, author: sqlxpertise.com
if found post useful, please "mark answer" or "vote helpful"

SQL Server  >  SQL Server Manageability