SQL 7.0 system OS requirements

SQL 7.0 system OS requirements

Post by A » Wed, 24 May 2000 04:00:00



I was wondering if SQL 7.0 can be installed on the following OS:
In the web they said to install on a NT 4.0 Server but I wanted to know if
we can install in the following OS
Windows NT 4.0 SP6 Workstation?
Windows 2000 Professional?
Windows 2000 Advanced Sever and higher...?
Thanking someone in advance
Denis

 
 
 

SQL 7.0 system OS requirements

Post by Neil Boy » Thu, 25 May 2000 04:00:00


W2K Professional and NT Workstation will only take the workstation
versions of SQL Server, which are more limited. W2K server is no
problem.
Neil Boyle
--
Visit the Impetus DBA Handbook - a free SQL Server guide at www.impetus-sql.co.uk

 
 
 

SQL 7.0 system OS requirements

Post by Neil Pik » Thu, 25 May 2000 04:00:00


Denis,

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
drivers.

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
same restrictions.

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:

exists).

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
internal exception

(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
SP1+.

(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.

===

v1.09 2000.03.27
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)
 or www.ntfaq.com/sql.html
 or www.sql-server.co.uk
 or www.mssqlserver.com/faq