Posted by NickName on 11/22/05 17:55

"notification is another issue altogether." And yet, it's almost
equally important, imho. OK, I've just looked up MAPI a bit and played
around a bit more about mail capability from sql server. Things that
confuse me about this damn mail thing with sql server is,

My understanding is,
mail may be sent via at least following two options
*) smtp server --> mua (mail user client, e.g. Outlook);
*) exchange server --> mua

My ENV is:
XP prof; sql server 2000; network-wise, I'm on two separate domains,
one handles email via exchange server etc. call it DomainX and another
does other stuff call it DomainY

The box's NT services include smtp service running under Local System
(attempts to use either domain user account failed). And yes it says
it is running (under system account). However, this service's UI does
not include any feature which indicates what IP it uses for the smtp
server, localhost or fqdn?

sql server 2000 and sqlagent services running under DomainY/myAccount
as suggested by some material (attempt to run them under
DomainX/myAccount failed)

RPC running under Local System (default)
RPC Locator running under Network service (default)

(And I must have done something a little while ago about setting up an
MAPI client like Outlook.) Now, when I go to Enterprise Manager, under
Support Services/SQL MAIL,
I have a MAPI profile and test to success. However, however, however,
when I attempted to run some sql extended procs for mail function like
xp_startmail, xp_sendmail, xp_stopmail I ran into errors, err msgs
include "failed with mail error 0x80004005". Searching for this err
msg has not generated interesting enough info.
Though the following thread was sort of interesting,
http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/d8574fa5e604b60/cf2e2c92c4a7e8db?q=MAPI+profile&rnum=2#cf2e2c92c4a7e8db
7. Michael J. McMurtrey 's writing is very good.

I suspect that it's related network security ...

FYI, I've also looked into another option, and again that may be
constrained by network security.

Any further thought?

Thanks.

[Back to original message]