Microsoft KB Archive/167751

= XFOR: All SQL Connections in Use =

Article ID: 167751

Article Last Modified on 9/30/2003

-

APPLIES TO


 * Microsoft Commercial Internet System 1.0 Service Pack 2

-



This article was previously published under Q167751



SYMPTOMS
Microsoft Commercial Internet System (MCIS) Service Pack 1 Internet Mail Server (IMS) pickup delivery causes all SQL connections in use errors in the SQL error logs.



CAUSE
The default setup for MCIS Service Pack 1 creates one type 15 routing source with a maximum of 10 concurrent connections. For normal SMTP client and server connected delivery, this is not a problem since there are only eight delivery threads by default. When pickup is used as well, there are eight more RT connecting threads activated (the eight pickup threads). Since there can only be 10 RT connections, and there are now 16 threads vying for those 10 connections, there are a large number of retried messages and DBSQL error event logs generated. Increasing the connection count to 20 does not correct this problem.



RESOLUTION
To work around this problem, add another routing source entry as a type 16 to the same SQL server. To do so, select SMTP in the Internet Service Manager, click the Directories tab, and then click the Routing Table button. From within this dialog box, you can add a second routing table entry as a subscriber only. If these errors persist, edit the routing source registry key entry and add the parameter "MaxCnx=20" to the following registry value:   HKey_Local_Machine\System\CurrentControlSet\Services\SmtpSvc\Parameters \RoutingSources\Source0 Use 20 as a baseline value for the MaxCnx= parameter, and then adjust upward as needed.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Commercial Internet System version 1.0.

Keywords: KB167751

-

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

© Microsoft Corporation. All rights reserved.