Controlling the number of active user connections

To set the number of active user connections from this site to remote servers, use number of remote logins. This command sets number of remote logins to 50:

sp_configure "number of remote logins", 50

Only a System Administrator can set the number of remote logins parameter.