I am using Windows XP professional and I have a network of 12 computers. I’m using one computer essentially as the “server” for a MSSQL database with other computers on the network accessing the data from it.
Any computer past the initial 10 computers that tries to access a program (that uses the MSSQL database in question) gets rejected, bounced, with the error message:
“\\server is not accessible. You might not have permission to use this network resource. Contact the administrator of this server to find out if you have access permissions. No more connections can be made to this remote computer at this time because there are already as many connections that the computer can accept.”
I have already looked at this supposed patch: http://www.lvllord.de/ (Update of TCPIP.SYS), but I can’t get it to work, i.e. raise the number of computer connections allowable under Windows XP professional. Some chat sites seem to imply that this is a feasible item, please tell me if so.
Thanks
Tags: Connections, I.e., Limit, Maximum, More, Tcp/ip, Than, There, Windows
The only fix is to install a server setup as a domain controller. This is by design by Microsoft.
This is because sharing resources can get too complicated with more than 10 computers. And if you want all of the resources to be on 1 PC with all of the other computers accessing these resources, Microsoft wants it to be a server.
You can get an entry level server with Windows 2003 server for about $2000. This would fix your problem.
Windows XP Professional allows a maximum of 10 other computers to connect to its shared resources simultaneously. Computers that aren’t actively connected to a computer’s shared resources don’t count against the limit. When a computer disconnects from a shared resource, it no longer counts against the limit. For details, see the article Inbound Connections Limit in Windows XP in the Microsoft Knowledge Base.http://support.microsoft.com/?scid=kb;en…
Have you thought of upgrading to Server 2003? There are NO limits to it.
MSSQL comes as a fixed licence install, you need to buy a licence pack to increase the number of client connections.