sql mail integration

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rajeev R - 27 Aug 2005 10:44 GMT

i have configured sql mail in sql server 2000.
the mailid is also successfully getting tested.
but when i execute the xp_sendmail command
i get the following error

Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80040107

do i have to apply any service pack

basically we have installed the sql server 2000 from windows sbs server 2003

Reply to this Message

io - 30 Aug 2005 11:58 GMT

Yes, you do have to instal SP3 at minimum. But that is not the issue this
time, I presume (although I might be wrong).

On the other hand, try to define some jobs that send a mail automatically.
The fact that you press Test does not mean anything. An by the way, do you
have a mail account configured correctly for the service? From your post I
cannot guess much about it.

Regards,
io

> i have configured sql mail in sql server 2000.
> the mailid is also successfully getting tested.
[quoted text clipped - 7 lines]
>
> basically we have installed the sql server 2000 from windows sbs server 2003

Reply to this Message