Max number of concurrent user connections for SQL 2005 Express

• james gagnon

  SSC Journeyman

  Points: 88

  More actions

  December 31, 2007 at 9:58 am

  #185237

  Hi, I'm trying to confirm whether or not SQL Express 2005 has a limit on the number of concurrent connections allowed. If I recall correctly MSDE has a limit of 5 connections but I've heard there is no limit for SQL Express.

  Can anyone confirm or deny this? Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738683

  More actions

  December 31, 2007 at 10:43 am

  #763743

  5 if on XP home, 10 on W2K Pro or XP Pro. OS limitations, not Express (http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx).

• james gagnon

  SSC Journeyman

  Points: 88

  More actions

  December 31, 2007 at 11:44 am

  #763767

  Thanks. After reading that article much becomes clear.