The actual number of user connections allowed also depends on the version of SQL Server installed and the limitations of your applications and hardware.
To reconfigure SQL Server for fewer connections you can use sp_configure. The number returned is not necessarily the number currently configured.
Syntax of @@MAX_CONNECTIONS Function :
@@MAX_CONNECTIONS
Return type of @@MAX_CONNECTIONS function is integer.
Examples of @@MAX_CONNECTIONS Function :
Example 1 : Use of @@MAX_CONNECTIONS function in select clause
SELECT @@MAX_CONNECTIONS
Output
32767
Above example returns number of simultaneous user connections allowed on sql server.