Q. What are the minimum hardware/software requirements for SQL Server?
A. That depends on whether you mean SQL Server "server" - i.e. the database
itself, or SQL Server client tools to setup/maintain the database. The below
table lists the requirements for both.
To just access SQL Server itself as a client then the only requirement is to be
able to run a db-lib/odbc/ole-db driver. These are available for just about
any platform - for non-Microsoft platforms you would need to get 3rd party
General notes on table :-
Where no hardware is mentioned then any hardware that runs the relevant version
of the NT operating system will also run SQL Server.
Unless otherwise specified SQL will run on any type of NT - workstation,
server, EE, etc. - though there may be licensing implications that you should
check first. With SQL 7.0 Microsoft are checking licensing restrictions in the
SQL setup program for the first time - e.g. you are unable to install the
Server edition onto NT workstation.
References to NT 5.0 are now replaced with Win2000.
If you run SQL Server on NT workstation then you are restricted by the maximum
number of incoming connections that NT allows. If you run SQL Server on a
connection-limited or evaluation copy of NT then SQL Server will suffer the
Systems Software requirements table
SQL 1.1 Server OS/2 1.30
SQL 1.1 Client Tools Dos, OS2, Win3x, Win9x, NT
SQL 4.20 Server OS/2 1.30, NT 3.1/3.5/3.51
SQL 4.20 Client Tools Dos/OS2/Win3x/Win9x/NT 3.1/3.5/3.51
SQL 4.21a Server NT 3.5/3.51
SQL 4.21a Client Tools Dos/OS2/Win3x/Win9x/NT 3.1/3.5/3.51
SQL 6.0 Server NT 3.51
SQL 6.0 Client Tools Win9x/NT 3.51
SQL 6.5 Server NT 3.51/4.0/Win2000 (2)
SQL 6.5 Client Tools Win9x/NT 3.51/4.0/Win2000
MSDE (SQL 7) Win9x/NT 4.0/Win2000 (1) (3)
SQL 7.0 Server "Desktop" Win9x/NT 4.0/Win2000 (1) (3)
SQL 7.0 Server "Server" NT 4.0 Server/Win2000 Advanced Server (1) (3)
SQL 7.0 Server "Enterprise" NT 4.0 EE/Win2000 DataCentre Server (1) (3)
SQL 7.0 Client Tools Win9x/NT 4.0/Win2000 (4)
SSDE (SQL 2000) Win98/NT 4.0/Win2000 (1) (5)
SQL 7.0 Server "Desktop" Win98/NT 4.0/Win2000 (1) (5)
SQL 7.0 Server "Server" NT 4.0 Server/Win2000 Advanced Server (1) (5)
SQL 7.0 Server "Enterprise" NT 4.0 EE/Win2000 DataCentre Server (1) (5)
SQL 7.0 Client Tools Win98/NT 4.0/Win2000 (6)
(1) Requires a Dec Alpha or 100% Intel PENTIUM compatible. It will not run on
486 machines or some AMD/Cyrix/IBM processors - it needs to support CMPXCHG8B
(Compare and Exchange 8 bytes) and RDTSC (Read Time-Stamp counter)
instructions. SQL 7.0 WILL run on Pentiums slower than 166Mhz, but Microsoft
do not "officially" support it. However, they are unlikely to refuse to take
your fault call and fix the problem, unless it is directly performance related.
The following quote is from Cyrix - "Recently an issue with SQL Server 7.0 has
been discovered with the non-MMX Media GX and the 6x86 processors. A fix for
this issue can be obtained from Cyrix technical support at:
If you do manage to get SQL 7/MSDE installed on a non-100% compatible pentium
then it will AV on start-up with the below messages. Because the MSDE setup
routine does not do as much checking as the SQL Server setup routines, it is
most likely that you will see this problem with MSDE.
2000-03-16 11:28:49.81 spid0 Using 'sqlimage.dll' version '4.0.5'
Stack Dump being sent to C:\msde\log\SQL00001.dmp
Stack Dump being sent to C:\msde\log\SQL00002.dmp
2000-03-16 11:28:53.84 spid0 Problem creating symptom dump file due to
internal exceptionUnable to get thread context - no pss
2000-03-16 11:28:53.86 spid0 Problem creating stack dump file due to
(2) DUMP/LOAD DATABASE fails with SQL 6.5 under Win2000 unless you have applied
at least 6.5 SP5
(3) SQL 7.0 requires NT4 SP4+ or Win2000 Beta2+. It also requires IE 4.01
(4) SQL 7.0 tools require IE 4.01 SP1+.
(5) SQL 2000 requires NT4 SP5+ or Win2000 RTM. It also needs IE 5.
(6) SQL 2000 tools require IE 5.
Applies to SQL Server versions : All
FAQ Categories : Installation and Upgrades
Related FAQ articles : n/a
Related Microsoft Kb articles : Q156437, Q229453
Other related information : n/a
Authors : Neil Pike
Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (428 entries) see
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7
- SQL Public)
I looking to prepare myself for Microsoft's certification test, 70-029. I
have an old Pentium Pro 200 MHz, running Win95 SP2. Can I run Microsoft SQL
Server 7.0, as a single user? I need to turn SQL Analyzer & Enterprise Mgr.