Microsoft KB Archive/811035

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:01, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


PRB: The xp_sendmail Stored Procedure Fails with Error 0x80070005 When the Mailbox of the SQL Mail Profile is Different From the MSSQLServer Service Startup Domain Account Default Mailbox

Article ID: 811035

Article Last Modified on 10/3/2003



APPLIES TO

  • Microsoft SQL Server 2000 Standard Edition



SYMPTOMS

When the SQL Mail profile is configured to use a Microsoft Outlook 2000 client exchange MAPI
profile that is configured to a Microsoft Exchange 2000 mailbox, the xp_sendmail extended stored
procedure may not be succesful, and you receive the following error message:


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

CAUSE

This behavior may occur if the Exchange Server mailbox configured for the SQL Mail
profile is different from the default mailbox of the domain account that is used to start
the Microsoft SQL Server services.

WORKAROUND

To work around this problem, you can use either of the following solutions:

  • Configure the SQL Mail profile to use the default mailbox of the domain account used

to start Microsoft SQL Server services.

-or-

  • Configure the SQL Mail profile as an Internet mail server (Post Office Protocol 3 [POP3]) profile.


Warning: Unless you can guarantee100 percent connectivity
to your Internet mail server without having to reauthenticate your mail logon,
SQL Mail may stop responding. If SQL Mail stops responding, you have to
stop and restart SQL Server. Use of an Internet mail server is not a recommended
solution but may be the only alternative in some cases.


For additional information about configuring the SQL Mail profile, click the following article number to view the article in the Microsoft Knowledge Base:

263556 INF: How to Configure SQL Mail


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.


REFERENCES

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

153159 HOW TO: Troubleshoot SQL Mail with Microsoft Exchange Server



315886 INF: Common SQL Mail Problems



321183 HOW TO: Troubleshoot Your SQL Mail Issue


293422 PRB: xp_sendmail Using a Microsoft Exchange 2000 Mailbox Fails with Mail Error 0x80004005 or 0x80007005


Keywords: kberrmsg kbsqlservmail kbprb KB811035