Fixed font
Subject: Re: Is there any MS operating system that can work in a workgroup and allows 30 connections
Author: Tecknomage Date: 19 Sep 2011
References: 1 2 3
Author: Tecknomage Date: 19 Sep 2011
References: 1 2 3
On Sat, 17 Sep 2011 00:03:34 -0700 (PDT), Paddy
<padmullaney@gmail.com> wrote:
First, you should be using a MS Server OS for what you want to do,
then the problem goes away. Just set it as a Workgroup Server (NOT
Domain).
We use "Windows Server 2003 Std" where I work (IT Tech) on our
Workgroup Fileserver (also our DNS Sever, Printer Server). Has both
Public and Private (user only) folders on a separate drive (D:) which
is backed-upped daily/weekly for Disaster Recovery.
The D: also includes a shared "Installs" folder which has the
installers for *most* of the apps we use. Therefore no need to use
CDs for installing/updating apps.
You should get a Server system for best results. A normal desktop
will be strained. Just make sure whatever you use has minimum 2gb
RAM, min 80gb for C: and a D: with enough disk space to store all
files/apps you want to share now *and in the future*. And a reminder,
you should install a very reliable Antivirus on servers.
Our server is a "DELL PowerEdge" .....
http://www.dell.com/us/business/p/servers
...that was customized via the option when we ordered it. For
servers, you SHOULD ALWAYS customize.
Note you can order it with the OS pre-installed and hard drives
pre-configured, just make sure you think it through before deciding.
One HIGHLY recommended custom option is the "DELL PowerVault RD1000"..
http://www.dell.com/us/business/p/powervault-rd1000/pd?refid=pvaul_rd1000
...using removable *hard drive* cartridges for backups. Also
"Symantec Backup Exec" software (do NOT have them install the backup
software included with PowerVault, you have to tell them this).
IMPORTANT NOTE: you can do a customized pre-order and SAVE it without
actually ordering. Then you can print it and discuss costs before
ordering or deleting the pre-order doc. Also suggest you phone sales
rep, give them the reference number or your pre-order and discuss all
options (especially about NOT installing PowerVault software).
Otherwise you may want to look at:
http://smallvoid.com/article/winnt-network-connection-limit.html
<padmullaney@gmail.com> wrote:
> Adam
>
> Your answer made me look again, and I have realised the problem does
> not lie with the sql connections, but we also our main application is
> also a document management system, so all the documents are shared and
> accessed on the same machine via a windows share, which means I have
> too many connections via file sharing, not sql. Sorry for the mistake.
>
> Paddy
>
> Your answer made me look again, and I have realised the problem does
> not lie with the sql connections, but we also our main application is
> also a document management system, so all the documents are shared and
> accessed on the same machine via a windows share, which means I have
> too many connections via file sharing, not sql. Sorry for the mistake.
>
> Paddy
First, you should be using a MS Server OS for what you want to do,
then the problem goes away. Just set it as a Workgroup Server (NOT
Domain).
We use "Windows Server 2003 Std" where I work (IT Tech) on our
Workgroup Fileserver (also our DNS Sever, Printer Server). Has both
Public and Private (user only) folders on a separate drive (D:) which
is backed-upped daily/weekly for Disaster Recovery.
The D: also includes a shared "Installs" folder which has the
installers for *most* of the apps we use. Therefore no need to use
CDs for installing/updating apps.
You should get a Server system for best results. A normal desktop
will be strained. Just make sure whatever you use has minimum 2gb
RAM, min 80gb for C: and a D: with enough disk space to store all
files/apps you want to share now *and in the future*. And a reminder,
you should install a very reliable Antivirus on servers.
Our server is a "DELL PowerEdge" .....
http://www.dell.com/us/business/p/servers
...that was customized via the option when we ordered it. For
servers, you SHOULD ALWAYS customize.
Note you can order it with the OS pre-installed and hard drives
pre-configured, just make sure you think it through before deciding.
One HIGHLY recommended custom option is the "DELL PowerVault RD1000"..
http://www.dell.com/us/business/p/powervault-rd1000/pd?refid=pvaul_rd1000
...using removable *hard drive* cartridges for backups. Also
"Symantec Backup Exec" software (do NOT have them install the backup
software included with PowerVault, you have to tell them this).
IMPORTANT NOTE: you can do a customized pre-order and SAVE it without
actually ordering. Then you can print it and discuss costs before
ordering or deleting the pre-order doc. Also suggest you phone sales
rep, give them the reference number or your pre-order and discuss all
options (especially about NOT installing PowerVault software).
Otherwise you may want to look at:
http://smallvoid.com/article/winnt-network-connection-limit.html
=========== Tecknomage ===========
Computer Systems Specialist
ComputerHelpForum.org Staff Member
IT Technician
San Diego, CA
Computer Systems Specialist
ComputerHelpForum.org Staff Member
IT Technician
San Diego, CA
