XFOR: All SQL Connections in Use (167751)
The information in this article applies to:
- Microsoft Commercial Internet System 1.0
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.
| Modification Type: | Major | Last Reviewed: | 9/30/2003 |
|---|
| Keywords: | KB167751 |
|---|
|