problem with xp

30 Sep 2005 7:52 AM

Hans

Hello,
I have the following problem.
I use the xp_sendmail often in the SQL query analyser with the folowing
script:

>>
USE MASTER
EXEC xp_sendmail

@recipients = 'hans.de.ko***@verder.nl',
@subject = 'Test mail',
@message = 'Testmail1'
<<
This worked OK for months.
After rebooting the SQL server I get the following error:

>>

Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80040111
<<
I checked the following issues in the enterprise manager:
1. Support services - SQL Mail > With Profilename 'xyz' After clicking
the Test-Button I get the message: 'Succesfully started and stopped a
MAPI session with this profile'
2. Management - SQL server agent > Working OK (same test and message as
described under '1. Support services '.
3. Management - SQL server agent - Operater 'Hans', E-mail name
'hans.de.ko***@verder.nl' then Test-button, final message: 'The message
was sent successfully' (I get the e-mail at my adress).

How can I solve this problem?

*** Sent via Developersdex http://www.developersdex.com ***

30 Sep 2005 8:31 AM

R.D

Hans
Have you checked these things. Most often xp_mail problems are not following
the steps in an order. As you told it ran for many months, most probably see
that the agent service and sql service *start* with the same domain
account(not local account)
Further Read this article
http://support.microsoft.com/kb/q299620/

Regards
R.D
Show quote

"Hans" wrote:

> Hello,
> I have the following problem.
> I use the xp_sendmail often in the SQL query analyser with the folowing
> script:
> >>
> USE MASTER
> EXEC xp_sendmail
> @recipients = 'hans.de.ko***@verder.nl',
> @subject = 'Test mail',
> @message = 'Testmail1'
> <<
> This worked OK for months.
> After rebooting the SQL server I get the following error:
> >>
> Server: Msg 18025, Level 16, State 1, Line 0
> xp_sendmail: failed with mail error 0x80040111
> <<
> I checked the following issues in the enterprise manager:
> 1. Support services - SQL Mail > With Profilename 'xyz' After clicking
> the Test-Button I get the message: 'Succesfully started and stopped a
> MAPI session with this profile'
> 2. Management - SQL server agent > Working OK (same test and message as
> described under '1. Support services '.
> 3. Management - SQL server agent - Operater 'Hans', E-mail name
> 'hans.de.ko***@verder.nl' then Test-button, final message: 'The message
> was sent successfully' (I get the e-mail at my adress).
>
> How can I solve this problem?
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
>

problem with xp_sendmail