Microsoft KB Archive/240877

= Sharing E-Mail Address Attribute May Cause SMTP Delivery Failure =

Article ID: 240877

Article Last Modified on 9/22/2005

-

APPLIES TO


 * Microsoft Site Server 3.0 Standard Edition
 * Microsoft Commercial Internet System 2.0

-



This article was previously published under Q240877



SYMPTOMS
SMTP service fails to deliver an e-mail message under the following conditions:
 * The e-mail message has several recipients.
 * One recipient uses an e-mail address shared by at least two membership accounts.

The following Windows NT application log event is generated:

Event 115

Source: PM Directory Store

SQL Error: HRESULT: 80004005 Minor Code: 512 Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC SQL Server Driver][SQL Server] Subquery returned more than 1 value...



CAUSE
When processing an e-mail message, SMTP contacts the LDAP server to get the mailbox location for the recipient's e-mail. The LDAP server then runs a specific stored procedure (sp_ims or sp_ims25 ) against the SQL Server membership database. These stored procedures fail if the "select" statement returns several results.



RESOLUTION
To resolve this problem, obtain the latest service pack for Site Server 3.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

219292 How to Obtain the Latest Site Server 3.0 Service Pack



STATUS
This problem was first corrected in Site Server 3.0 Service Pack 3.



MORE INFORMATION
Keywords: kbbug kbfix kbqfe kbhotfixserver KB240877

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.