Microsoft KB Archive/820220

= PRB: 0x80070005 or 0x80040005 Error Occurs When You Send E-Mail by Using the Xp_sendmail Extended Stored Procedure =

Article ID: 820220

Article Last Modified on 5/8/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



SYMPTOMS
When you use the xp_sendmail extended stored procedure to send e-mail from SQL Mail with SQL Server 2000, you might receive one of the following error messages:

Server: Msg 18025, Level 16, State 1, Line 0

xp_sendmail: failed with mail error 0x80070005

-or-

Server: Msg 18025, Level 16, State 1, Line 0

xp_sendmail: failed with mail error 0x80040005



CAUSE
The alias name of the Microsoft Exchange 2000 mailbox that is configured for the SQL Mail profile contains special characters such as a period (&quot;.&quot;), or the at sign (@). For example, Sql.mail.



WORKAROUND
To work around the problem, create a new Microsoft Exchange 2000 mailbox with an alias that does not contain any special characters, and then configure the mailbox for the SQL Mail profile.



MORE INFORMATION
SQL Mail uses extended MAPI for submitting e-mail messages to the MAPI spooler for delivery (SubmitMessage API call). The SubmitMessage procedure tries to parse the alias name, and it truncates the alias name when the procedure encounters a special character. Because the alias name is truncated, MAPI cannot find a mailbox or security credentials, or both, to match with the mailbox. Hence, you might receive an &quot;access denied&quot;, 0x80070005, or 0x80040005 error.

When you use the Microsoft Outlook client on a computer that is running SQL Server, and you use the SQL Server Agent to send e-mail messages, the delivery of the messages is not affected by this configuration. SQL Agent Mail and Microsoft SQL Server 7.0 SQL Mail use the Simple MAPI API call to perform xp_sendmail operations. The Simple MAPI method (MAPISendMail API call) for delivering e-mail is not affected by the special characters.

