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.korte@.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.korte@.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.examnotes.net ***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
"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.korte@.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.korte@.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.examnotes.net ***
>
Wednesday, March 7, 2012
problem with xp_sendmail
Labels:
analyser,
database,
following,
folowingscript,
masterexec,
microsoft,
mysql,
oracle,
query,
server,
sql,
xp_sendmail
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment