xp_sendmail on SQL Server 8.00.534 fails with error 0x80040111 
Author Message
 xp_sendmail on SQL Server 8.00.534 fails with error 0x80040111

I am using:


* Windows 2000 (SP2 + current patches) member server, in a
* Windows NT domain.

I have the services starting under a domain account, natch.  I can log in to
the member server with that domain account, launch Outlook 2000, and send
myself e-mail.  (We are using Exchange 5.5 Server.)  I can also fire up
Enterprise Manager, look at the SQL Server Agent properties, select the
relevant mail profile (the name of which is less than 25 characters in
length), and click "Test" to get a success message.

However, if I try to use xp_startmail or xp_sendmail, I get an error message
that the service "failed with mail error 0x80040111".  I have some jobs that
send mail using xp_sendmail, so obviously, I'd like to fix this problem
since the mail isn't being sent.

Oddly enough, using xp_stopmail will succeed if I use it once; and return
"SQL Mail session is not started" if I use it a second time.  However, if I
use xp_startmail after that, I get the "0x80040111" error message yet I can
then use xp_stopmail successfully again.

Thanks in advance for any help!

Cheers,

Brian J. Parker



Sat, 25 Sep 2004 22:33:41 GMT
 xp_sendmail on SQL Server 8.00.534 fails with error 0x80040111

That's the MAPI error number for MAPI_E_LOGON_FAILED. Being
that you are finding problems with xp_sendmail, you should
check the mail profile used by SQL Mail which would be the
SQL Server service account. xp_sendmail uses the SQL Server
service account.
SQL Agent mail properties and the SQL Agent service account
are used when sending notifications from jobs, alerts, etc.
You can find more info in the following Knowledge Base
article:
INF: How to Configure SQL Mail (Q263556)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556

-Sue

On Tue, 9 Apr 2002 10:33:41 -0400, "Brian J. Parker"

Quote:

>I am using:


>* Windows 2000 (SP2 + current patches) member server, in a
>* Windows NT domain.

>I have the services starting under a domain account, natch.  I can log in to
>the member server with that domain account, launch Outlook 2000, and send
>myself e-mail.  (We are using Exchange 5.5 Server.)  I can also fire up
>Enterprise Manager, look at the SQL Server Agent properties, select the
>relevant mail profile (the name of which is less than 25 characters in
>length), and click "Test" to get a success message.

>However, if I try to use xp_startmail or xp_sendmail, I get an error message
>that the service "failed with mail error 0x80040111".  I have some jobs that
>send mail using xp_sendmail, so obviously, I'd like to fix this problem
>since the mail isn't being sent.

>Oddly enough, using xp_stopmail will succeed if I use it once; and return
>"SQL Mail session is not started" if I use it a second time.  However, if I
>use xp_startmail after that, I get the "0x80040111" error message yet I can
>then use xp_stopmail successfully again.

>Thanks in advance for any help!

>Cheers,

>Brian J. Parker



Sat, 25 Sep 2004 22:49:58 GMT
 xp_sendmail on SQL Server 8.00.534 fails with error 0x80040111

Quote:
> That's the MAPI error number for MAPI_E_LOGON_FAILED. Being
> that you are finding problems with xp_sendmail, you should
> check the mail profile used by SQL Mail which would be the
> SQL Server service account. xp_sendmail uses the SQL Server
> service account.

Aha.  I feel so silly now-- I checked and re-checked the SQL Agent
properties, combed the knowledge base, re-applied the service pack... and
for something I really ought to have remembered!  I had the mail profile
name wrong for the SQL Server service.

Cheers,

Brian



Sat, 25 Sep 2004 23:11:31 GMT
 xp_sendmail on SQL Server 8.00.534 fails with error 0x80040111
Brian,

Great to hear all is well now. I'd not feel silly, SQL Mail is not the
easiest thing to get setup, and setup correctly.
The SQL Mail KB is one of our most popular articles.

Reinaldo Kibel
Microsoft? Corp. - SQL Server Support Engineer

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2002 Microsoft Corporation. All rights
reserved.

Additional support can be obtained at http://support.microsoft.com

Are you secure?  For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------

|


| > That's the MAPI error number for MAPI_E_LOGON_FAILED. Being
| > that you are finding problems with xp_sendmail, you should
| > check the mail profile used by SQL Mail which would be the
| > SQL Server service account. xp_sendmail uses the SQL Server
| > service account.
|
| Aha.  I feel so silly now-- I checked and re-checked the SQL Agent
| properties, combed the knowledge base, re-applied the service pack... and
| for something I really ought to have remembered!  I had the mail profile
| name wrong for the SQL Server service.
|
|
| Cheers,
|
| Brian
|
|
|
|



Sun, 26 Sep 2004 01:41:12 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Strange behaviour of is_member() in SQL-Server 2000 (Product Version 8.00.534, S

2. Strange behaviour of is_member() in SQL-Server 2000 (Product Version 8.00.534, S

3. SQL Mail Error (xp_sendmail: failed with mail error 0x80040111)

4. XP_SendMail error 18025 (0x80040111)

5. Error 18025 : xp_test_mapi_profile failed with mail error 0x80040111

6. xp_sendmail on SQL 7.00.961

7. Help with 00:00:00:00 format

8. Bad Timestamp Format at 19 in 1974-08-02 00:00:00.00+01] in PostgresQL

9. SET EXPLAIN: Error -534

10. Answer to SET EXPLAIN: Error -534

11. Error 534 & onlinefiles

12. how do i get only the date format from 2001-01-01 00:00:00.000


 
Powered by phpBB® Forum Software