SQL Servers

[Guest]

I am a new industrial technology teacher and I have a modular lab that has
software that sets up a sql server, I was told that I needed Windows Sever
because I have more that 10 computers. All of the other computer labs in the
school use XP Pro and I am familiar with this program and networking with it.
I am not with Server. Does the sql server have something to do with the need
for Windows server or can I use XP Pro. I have enough software problems from
the modules and I do not want to add another that I am not familiar with if I
do not have to. Does any one know anything that can help me?

 

[Patrick Keenan]

I am a new industrial technology teacher and I have a modular lab that has
software that sets up a sql server, I was told that I needed Windows Sever
because I have more that 10 computers. All of the other computer labs in the
school use XP Pro and I am familiar with this program and networking with it.
I am not with Server. Does the sql server have something to do with the need
for Windows server or can I use XP Pro. I have enough software problems from
the modules and I do not want to add another that I am not familiar with if I
do not have to. Does any one know anything that can help me?

The issue is almost certainly the number of connections supported by XP vs.
Server. XP allows 10 connections (XP Home allows 5), and IIRC you can
reach that limit with less than 10 machines depending on the software that's
run.

http://support.microsoft.com/?scid=kb;en-us;314882

The short version is that if you use XP Pro to host SQL Server in a lab with
over 10 client machines, you will quickly (if not immediately) run into
situations where some users can *not* connect till others shut down. To
get around it, you must use a Server OS that supports the higher number of
connections.

HTH
-pk