Number of active connections in SQL Server 2005

• manuelroman98

  Mr or Mrs. 500

  Points: 593

  More actions

  November 10, 2010 at 10:59 am

  #149301

  Hi Forum,

  How and where can i find out what the number of active connections is in SQL Server 2005.

  I know that the default number of connections is 32767, but how can i set/change the number of connections allowed in SQL?

  When i do

  sp_configure

  go

  I got the following:

  MIN MAX config_value run_value

  allow updates0100

  clr enabled0100

  cross db ownership chaining0100

  default language0999900

  max text repl size (B)021474836476553665536

  nested triggers0111

  remote access0111

  remote admin connections0100

  remote login timeout (s)021474836472020

  remote proc trans0100

  remote query timeout (s)02147483647600600

  server trigger recursion0111

  show advanced options0100

  user options03276700

  The only thing that i can see is "user options" with a max of 32767 and under config_value shows "0".

  Is there a way to set a fix number of user connection to the server???

  Thanks in advance.

  Regards,

  Manuel Roman

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738960

  More actions

  November 10, 2010 at 11:04 am

  #1249063

  http://msdn.microsoft.com/en-us/library/ms187030.aspx

  Advanced option.

  http://msdn.microsoft.com/en-us/library/ms187882.aspx

• manuelroman98

  Mr or Mrs. 500

  Points: 593

  More actions

  November 10, 2010 at 11:17 am

  #1249074

  Steve,

  Thank you very much...

  Greatly appreciated.

  Regards,

  Manuel