Microsoft KB Archive/811035

= 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.

