Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer 1

up vote 3 down vote accepted

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.

share|improve this answer
    
In other words: yes the limit applies, but it won't be enforced and will probably work anyway? –  Joel Coel Jun 30 '09 at 17:01
    
That is my impression. –  Jack B Nimble Jun 30 '09 at 17:21
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.