Hi everyone, I've got a potential big client who is looking for a hardware configration for our system. Our system utilizes VFP for the front-end and SQL Server 2000 for the backend. They are wanting to standup 30 facilities with 30 users each. Each facility data would be independent of each others, so I can just have a seperate database for each facility inside SQL Server. They are wanting to utilize Terminal Server for providing access to the application. They already have a secure wan in place (I'm not sure of it's configuration). Here is my first idea of the proposed hardware:

Option #1: Using Terminal Services

For running in a centralized terminal server environment, we would recommend two machines for the application servers, configured in a clustered environment to provide fail-over capability.  Each Application Server would be consists of:

Application Server
4-Way  XEON MP Processors (Expandable to 8)
Windows 2003 Server OS Enterprise Edition
Terminal Services Installed and Licensed for 900 users (30 sites x 30 Users each)
16 Gigs of Ram (Expandable to 32)
2 – 140 Gig Hard Drives with Raid Configuration
Gigabyte Network adapter to backbone

The database servers would be on separate machines, once again we suggest two machines in a clustered environment for fail-over.  Each site would have it’s own separate database within the SQL Server 

Database Server
4-Way  XEON MP Processors (Expandable to 8)
Windows 2003 Server OS Enterprise Edition
16 Gigs of Ram (Expandable to 32)
4 – 140 Gig Hard Drives with Raid Configuration
Gigabyte Network adapter to backbone

I'm no hardware guru, so any suggestions would be greatly appreciated.


Thanks
Kirk