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 (811035)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
SYMPTOMSWhen 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
CAUSEThis 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.WORKAROUNDTo 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
Modification Type: | Major | Last Reviewed: | 10/3/2003 |
---|
Keywords: | kberrmsg kbprb kbSQLServMail KB811035 kbAudDeveloper |
---|
|