• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

xp_sendmail error

This morning users reported the following:

Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80004005

Our SqlServer 2000 runs under Exchange 2003 SP3. I contacted IT tech support and was asked: " what service account did that sql request come from?". How can the service account issueing the send mail request be identified?

Thanks.
0
ksfok
Asked:
ksfok
  • 2
1 Solution
 
Eugene ZCommented:
<what service account did that sql request come from?".
MSSQL service NT account
You need to login on the box as the NT account and open MS outlook (MAPI profile needs to be created -> it is used for xp_sendmail
)


please revieW:

INF: How to Configure SQL Mail
http://support.microsoft.com/kb/263556/EN-US/
---
INF: Common SQL Mail Problems
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22960711.html
---------------------
--if everything is fine on sql server site check:


http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21664068.html


xp_sendmail using a Microsoft Exchange 2000 mailbox fails with mail error 0x80004005 or 0x80007005
http://support.microsoft.com/default.aspx/kb/293422

http://support.microsoft.com/default.aspx/kb/820220
0
 
ksfokAuthor Commented:
Sorry the link you provided under "INF: Common SQL Mail Problems" is wrong. It sends back here.
0
 
Eugene ZCommented:


INF: Common SQL Mail Problems
http://support.microsoft.com/kb/315886
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now