SQL Server Properties (Connections Tab)
Use this tab to view or specify the following options.
Options
Maximum concurrent user connections
Specify the maximum concurrent user connections. Entering zero means there can be an unlimited number of concurrent user connections.
Default connection options
Specify the default connection options for the selected server.
Allow other SQL Servers to connect remotely to this SQL Server using RPC
Allow other instances of Microsoft® SQL Server™ to connect remotely to this server by using a remote procedure call (RPC).
Query time-out (seconds)
Specify the number of seconds that must elapse during a remote query before the query times out. Specifying zero means that an unlimited amount of time can elapse.
Enforce distributed transactions (MTS)
Protect a server-to-server procedure by using Microsoft Distributed Transaction Coordinator (MS DTC) to coordinate distributed transactions.
Configured values
View or change the configured values for the options on this tab. If you change these values, click Running values to see whether the changes have taken effect. If they have not, you must restart the instance of SQL Server for the changes to be implemented.
Running values
View the current running values for the options on this tab. These values are read-only.