Re: Max Connections

Tech-Archive recommends: Fix windows errors by optimizing your registry

I asked you this cause this kind of limitation is easy to understand with NAMED PIPE cause this is linked to OS.
But I'm not sure this limit apply to TCP connections.

"kishor" <kishor@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de news:820984B0-01A3-4FF6-AC79-4653400F3D5D@xxxxxxxxxxxxxxxx
Hi,
I was just going through this page

http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx

I found this.

Regards,
kishor


"Pascal Deliot" wrote:

Where have you found these limitation?
If found by test, have you only uses NAMED PIPES? Or have you tried TCP
connection too?

"kishor" <kishor@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le message de
news:55CBB500-1C29-47BF-A2B1-4CEEF36031EE@xxxxxxxxxxxxxxxx
> Hi,
> If SQL Server 2005 Express is running on Windows XP Home, it is limited > to
> five simultaneous connections. If it is running on Windows 2000 or > Windows
> XP
> Professional, it is limited to 10 simultaneous connections. However, > these
> are limitations of the operating system and not of SQL Server 2005 > Express
>
> Where are the setting of this ? can we modify this ?
>
> TIA,
> Kishor



.

Relevant Pages

  • Re: Max Connections
    ... Where have you found these limitation? ... If it is running on Windows 2000 or Windows XP ... it is limited to 10 simultaneous connections. ...
    (microsoft.public.sqlserver.clients)
  • Re: Maximum connection allowed to connect shared folder in WinXPPro
    ... Windows XP Pro has a maximum of 10 simultaneous connections. ... The Teacher PC should probably consider moving to the Windows 2000 Small ... > connection to shared folder when more then 10 computers are trying to ...
    (microsoft.public.windowsxp.network_web)
  • Re: IP Conflict
    ... simultaneous connections when not on a domain, ... > I'm running a host computer, HP Pavilian, Windows XP Media Center w/SP2, ... > with a Linksys wireless router. ... > A few minutes after client connection, the client signal drops and the ...
    (microsoft.public.windowsxp.network_web)
  • Re: Is there a limit on the amount of people listening to my broadcast
    ... If you have XP Home you are limited to 5 simultaneous connections ... Windows 2003 Small Business Server allows 75 simultaneous connections ... > wondering why i couldnt get past 5 people listening to my ...
    (microsoft.public.windowsmedia.encoder)
  • Re: 2 printers only?
    ... XP Home allows 5 simultaneous connections ... Windows 2000 SBS allows 49 simultaneous connectiins ... > I run a network on Windows NT 4 server, with a mix of XP and NT clients. ... > Some of my clients need to connections to numerous printers. ...
    (microsoft.public.windowsxp.print_fax)