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                    Windows NT Enterprise Edition 4.0
Enterprise Edition     

6.5                    Windows 2000 Server RC3 or later.    
Enterprise Edition     
with Service Pack 5a

6.5                    Windows 2000 Advanced Server
Enterprise Edition     RC3 or later.
with Service Pack 5a   

6.5                    Windows 2000 Datacenter Server
Enterprise Edition     with no more than 2 nodes and RC3
with Service Pack 5a   or later. 
                                     
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.  

7.0                   
Enterprise Edition    Windows 2000 Advanced Server, 
with Service Pack 1   or Windows 2000 Datacenter Server.

<MSONLY>
As of 1/26/2000, if you are running Windows 2000 Datacenter Server, you can
have a maximum of two nodes. This limitation will likely be removed when
Windows 2000 Datacenter Server is released.
</MSONLY>

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.

All versions prior to SQL Server 7.0 SP1 are not supported on the Microsoft Terminal Server.

Additional query words: winnt sql 6 os

Keywords : kbenv kbinterop kbsetup SSrvGen SSrvInst kbNTOS350 kbNTOS351 kbNTOS400 kbSQLServ kbSQLServ600 kbSQLServ650 kbSQLServ700 SSrvWinNT
Version : winnt:3.5,3.51,4.0,4.2x,6.0,6.5,7.0
Platform : winnt
Issue type : kbinfo