INF: How to Increase SQL Server Multi-Protocol Connections (166270)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5
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.
Modification Type:MinorLast Reviewed:2/14/2005
Keywords:kbenv kbinfo kbnetwork KB166270
©2004 Microsoft Corporation. All rights reserved.