INF: Supported Windows Versions for SQL Server

ID: Q122352

The information in this article applies to:

Microsoft SQL Server versions 4.2x, 6.0, 6.5, 7.0
Microsoft Windows NT, versions 3.5, 3.51, 4.0

SUMMARY

This article lists the Windows operating system versions on which Microsoft SQL Server versions 4.2x, 6.0, 6.5 and 7.0 are supported.

MORE INFORMATION

The version of SQL Server can be determined by executing the following query:


select @@version

The version of SQL Server is also reported in the first line of the error log.

You can find the version of Windows NT you are running by going to the command prompt and typing winver.


SQL SERVER
VERSION               WINDOWS VERSION
-------------         ------------------------------------------
4.20                  Windows NT 3.1/Windows NT Advanced Server 3.1

4.21                  Windows NT 3.1/Windows NT Advanced Server 3.1
(includes
4.21 Desktop
System)

4.21a                 Windows NT 3.1/Windows NT Advanced Server 3.1
                      Windows NT Server 3.5/3.51

4.21a                 Windows NT 3.1/Windows NT Advanced Server 3.1
Workstation           Windows NT Workstation 3.5/3.51
System                Windows NT Server 3.5/3.51


6.0                   Windows NT Server 3.5/3.51

6.0                   Windows NT Server 3.5/3.51
Workstation           Windows NT Workstation 3.5/3.51
System

6.5                   Windows NT Server 3.51

6.5                   Windows NT Server 3.51
Workstation           Windows NT Workstation 3.51
System

6.5
Enterprise Edition    Windows NT Enterprise Edition 4.0

7.0
Enterprise Edition    Windows NT Server Enterprise Edition 
                      version 4.0 or later with SP4 or later

7.0
Standard Edition      Windows NT Server 4.0 or later with SP4 or 
                      later, or Windows NT Server Enterprise Edition
                      version 4.0 or later with SP4 or later

7.0 
Desktop Edition       Windows 95, Windows 98, Windows NT 
                      Workstation 4.0 or later with SP4 or later, or 
                      one of the valid operating systems listed listed
                      for SQL Server 7.0 Standard or Enterprise Edition 
                      above.

Version-Specific Notes

SQL Server 4.21a with Service Pack 4 requires Windows NT 3.5 or 3.51.

Although version 6.0 is supported on Windows NT 3.5, the preferred platform is version 3.51. Version 6.0 Is NOT supported on Windows NT 4.0.

SQL Server 6.0 with Service Pack 3 requires Windows NT 3.51.

SQL Server 6.5 is NOT supported on Windows NT version 3.5.

SQL Server 6.5 is supported on Windows NT 4.0.

The Enterprise Edition was released in December, 1997 to add support for increased memory sets, Windows NT clustering, Natural Language query processing (Microsoft English Query), and scalability for servers with more than four processors.

Because many of the extensions cooperate with comparable extensions in the operating system, SQL Server 6.5 Enterprise Edition must be installed on a Windows NT Server 4.0 Enterprise Edition server. There are checks in the SQL Server 6.5 Enterprise Edition setup program to verify that Windows NT Server 4.0 Enterprise Edition is the operating system.

SQL Server 7.0 is not supported on Microsoft Terminal Server.

Additional query words: winnt sql 6 os


Keywords          : kbenv kbinterop kbsetup SSrvGen SSrvInst SSrvWinNT 
Version           : winnt:3.5,3.51,4.0,4.2x,6.0,6.5,7.0
Platform          : winnt 
Issue type        : kbinfo

Last Reviewed: July 13, 1999