Home / server / Questions / 33850
Accepted
Florian Fankhauser
Asked: 2009-07-01 06:29:15 +0800 CST

Does Windows XP connection limit apply to Sql Server connections?

  • 772

I have installed Sql Server 2005 on Windows XP acting as server in a small workgroup. Since XP has as limit of 10 computers connecting at the same time, my question is, does this limit also apply to concurrent connections over TCP/IP to the Sql Server? Or does this limit only apply to connections to shares, printers and so on?

sql-server windows-xp

1 Answers

  1. Best Answer

    This article states maximum of 10 connections.

    For Windows XP Professional, the maximum number of other computers that are permitted to simultaneously connect over the network is ten. This limit includes all transports and resource sharing protocols combined. For Windows XP Home Edition, the maximum number of other computers that are permitted to simultaneously connect over the network is five. This limit is the number of simultaneous sessions from other computers the system is permitted to host

    Although

    The connection limit refers to the number of redirector-based connections and is enforced for any file, print, named pipe, or mail slot session. The TCP connection limit is not enforced, but it may be bound by legal agreement to not permit more than 10 client

    These people seem to have copied or created a tcpip driver that enables up to 50 connections.

    It is not clear to me if they took TCPIP.SYS from another microsoft operating system or if they somehow wrote their own.

    • 3