INF: How to Increase SQL Server 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.