Microsoft KB Archive/166270

= INF: How to Increase SQL Server Multi-Protocol Connections =

Article ID: 166270

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q166270



SUMMARY
The default setting of the Multi-Protocol Net-Library on the server-side can support up to 1,024 concurrent client connections. This article provides information on how to configure SQL Server to accept more than 1,024 concurrent Multi-Protocol connections.



MORE INFORMATION
To configure SQL Server to support more than 1,024 concurrent Multi- Protocol client connections, you need to add a key in the Windows NT registry.

WARNING: Using Registry Editor incorrectly can cause serious, system-wide problems that may require you to reinstall Windows NT to correct them. Microsoft cannot guarantee that any problems resulting from the use of Registry Editor can be solved. Use this tool at your own risk.

Registry branch: HKEY_LOCAL_MACHINE on LOCAL_MACHINE Key path:       Software\Microsoft\MSSQLServer\MSSQLServer\RPCNetlib Key value:      MaxCalls REG_DWORD

Set the value of this key as desired. The default value of the key is 1024.

NOTE: Do not set this value higher than you really need, or memory resources will be wasted.

Additional query words: rpc max maximum limitation upper limit

Keywords: kbinfo kbenv kbnetwork KB166270

-

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

© Microsoft Corporation. All rights reserved.