>Hello all, I need to specify hardware ( the server ) requirements for a SQL Server 2000 app, the app will be accessed in house by approx 25 users , is there anything I need to know above the normal memory and diskspace requirements ?, e.g. do I need multiple processors ? , unfortunately the person usually allocated this task is not available - hence this question, many thanks


FROM BOL
Hardware Minimum requirements
Computer Intel® or compatible
Pentium 166 MHz or higher.

Memory (RAM)1 Enterprise Edition: 64 MB minimum, 128 MB or more recommended
Standard Edition: 64 MB minimum

Personal Edition: 64 MB minimum on Windows 2000, 32 MB minimum on all other operating systems

Developer Edition: 64 MB minimum

Desktop Engine: 64 MB minimum on Windows 2000, 32 MB minimum on all other operating systems

Hard disk space2 SQL Server database components: 95 to 270 MB, 250 MB typical
Analysis Services: 50 MB minimum, 130 MB typical

English Query: 80 MB

Desktop Engine only: 44 MB

Monitor VGA or higher resolution
800x600 or higher resolution required for the SQL Server graphical tools

Pointing device Microsoft Mouse or compatible
CD-ROM drive Required
1 Additional memory may be required, depending on operating system requirements.
2 Actual requirements will vary based on your system configuration and the applications and features you choose to install.



Operating System Requirements
This table shows the operating systems that must be installed to use the various editions or components of Microsoft SQL Server 2000.

SQL Server edition or component
Operating system requirement
Enterprise Edition: Microsoft Windows NT Server 4.0, Microsoft Windows NT Server Enterprise Edition 4.0, Windows 2000 Server, Windows 2000 Advanced Server, and Windows 2000 Data Center Server.
Note that Microsoft Windows 2000 Server (any version) is required for some SQL Server 2000 features.

Standard Edition: Microsoft Windows NT Server 4.0, Windows 2000 Server, Microsoft Windows NT Server Enterprise Edition, Windows 2000 Advanced Server, and Windows 2000 Data Center Server.
Personal Edition: Microsoft Windows Me, Windows 98, Windows NT Workstation 4.0, Windows 2000 Professional, Microsoft Windows NT Server 4.0, Windows 2000 Server, and all the more advanced Windows operating systems.
Developer Edition: Microsoft Windows NT Workstation 4.0, Windows 2000 Professional, and all other Windows NT and Windows 2000 operating systems.
Client Tools Only: Microsoft Windows NT 4.0, Windows 2000 (all versions), Windows Me, and Windows 98.
Connectivity Only: Microsoft Windows NT 4.0, Windows 2000 (all versions), Windows Me, Windows 98, and Windows 95.




Note Microsoft Windows NT® Server 4.0, Service Pack 5 (SP5) or later must be installed as a minimum requirement for all SQL Server 2000 editions.

SQL Server 2000 is not supported on Windows NT 4.0 Terminal Server.


For installations of SQL Server 2000 Personal Edition on Windows 98 computers without a network card, Windows 98 Second Edition is required.