May 23, 2003 at 11:59 am
I am in query analyser, with the same admin user group account, which started SSAgent service. I am trying xp_sendmail, and it gives me an error message like this:
xp_sendmail: failed with mail error 0x80004005
What could be the reason? Any help, thanks in advance.
May 23, 2003 at 12:28 pm
Also, I am trying to run the same thing in production, it gives me an error like this:
xp_sendmail: Procedure expects parameter @user, which was not supplied.
Any help will be greatly appreciated.
May 23, 2003 at 1:07 pm
Hi,
This KB article refers to the same error(w.r.to Exchange 2000)
http://support.microsoft.com/default.aspx?scid=KB;en-us;293422&
another KB article that might be useful is
http://support.microsoft.com/default.aspx?scid=KB;en-us;263556&
about the "xp_sendmail : Procedure expects paramater @User" - I have never faced this error(I use SQL 7.0 btw)...the closest I could find on BOL is a parameter called @set_user which sets the security context in which the query should be run(which defaults to "guest")....
what we normally do whenever SQL mail starts acting up is as follows :
a)Stop and start SQL Server Agent
b)use xp_stopmail and xp_startmail from Query Analyser to stop and start the mail session
c)use xp_sendmail from the query analyser(most of the time it starts working here)...
let me know if this has been of any help....
May 23, 2003 at 6:12 pm
It works finally. Thanks much !!!
My jobs were sending mails, since it was using agent service. In this server, these 2 services were under different account.
xp_sendmail uses sqlserver service. I had to restart the service, with the same account of agent service. I goes boong !!
Glad to be part of this group. It saved my day.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply