Sharing E-Mail Address Attribute May Cause SMTP Delivery Failure

ID: Q240877

The information in this article applies to:

Microsoft Site Server version 3.0
Microsoft Commercial Internet System version 2.0

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, please see the following article in the Microsoft Knowledge Base:

Q219292 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

Additional query words:

Keywords : SS3SP3Fix
Version : winnt:2.0,3.0
Platform : winnt
Issue type : kbbug