Home > Archive > MS SQL Server > October 2006 > xp_sendmail









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author xp_sendmail
vinu thomas

2006-10-24, 6:28 pm

Hi
xp_sendmail is failing with following error.

xp_sendmail: failed with mail error 0x80040111

Our Windows server runs five SQL server instance. I have configured the MAPI
profile on the windows server and specified the profile name in support
service, SQL mail as well. Both SQL start up service and agent service uses
the same login name. xp_sendmail works fine for the first instance, not for
others.
Why, what could be the problem..

Thanks



Sue Hoegemeier

2006-10-24, 6:28 pm

Are the two instances using two different service accounts?
You could be hitting a limitation with the MAPI subsystem -
check the following article:
BUG: SQL Mail Only Works From One Instance at a Time
http://support.microsoft.com/?id=327552

-Sue

On Thu, 14 Sep 2006 02:25:01 -0700, vinu thomas
< vinuthomas@discussio
ns.microsoft.com> wrote:

>Hi
>xp_sendmail is failing with following error.
>
>xp_sendmail: failed with mail error 0x80040111
>
>Our Windows server runs five SQL server instance. I have configured the MAPI
>profile on the windows server and specified the profile name in support
>service, SQL mail as well. Both SQL start up service and agent service uses
>the same login name. xp_sendmail works fine for the first instance, not for
>others.
>Why, what could be the problem..
>
>Thanks
>
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com