sql server xp_sendmail and xp_readmail aren't working.
Posted on 2004-09-28
Once again I have MS mistery to deal with.
I'm trying to user xp_sendmail adn xp_readmail to send exit status or to trigger execution of DTS packages.
Did all the necessary steps - created the SQLSERVER domain user, exchange e-mail box for the user, reconfigured sql server and sql server agent processes to start as Administrator account, granted all the necessary privileges to send and read the e-mails as SQLSERVER user to Administrator account.
So now I can. Open MS Outlook and receive the SQLSERVER e-mails with outlook. Start MS SQL Server Enterprise console get to Support Services of the server, bring up SQLMail properties and successfully start/stop with set MAPI profile.....
But if open the SQL query analyzer - and run xp_sendmail I would be getting the error :
"xp_sendmail: failed with mail error 0x80004005"
If I try to run xp_findnextmsg I still get :
"xp_findnextmsg: failed with mail error 0x80004005"
To be honest I already deployed other package which successfully sends out smtp messages, but since I have to receive messages I'm still trying to make SQL Mail work....
Here is the question - do we have any substitute to xp_readmail... I there is none what should I do to make MS thing work.
Thanks a lot in advance.