MICROSOFT SQL SERVER SUPPORT FOR OS/2 2.1 Microsoft SQL Server version 4.2 for OS/2 is supported on OS/2 versions 1.3 and 2.1. Although typically used in multi- user environments, the server is designed to allow stand- alone operation so that no networking software is required for single-user operation. In the more common multi-user environment, the server relies on networking software, such as Microsoft LAN Manager version 2.2, to provide interprocess communication services. Microsoft SQL Server 4.2 is currently supported on OS/2 2.1 as both a client and server platform in IBM and Novell network environments. It may also be run in a stand-alone, single-user configuration without any network software. However, for most sites it is recommended that you use OS/2 version 1.3, which ships with SQL Server, as the preferred operating system for the server software. OS/2 version 1.3 is stable and is widely supported in all LAN environments. SUPPORT FOR WINDOWS-BASED APPLICATIONS It is recommended that you run Windows-based applications in their native environment, on Microsoft Windows version 3.1. However, Windows-based applications that access SQL Server will run on OS/2 version 2.1 as long as you are using LAN Manager version 2.2 or IBM LAN Server version 3.0. Internal testing has not found Windows-based applications on OS/2 version 2.1 to be a platform stable enough to recommend with other networking software. NETWORK COMPATIBILITY Microsoft SQL Server can operate on OS/2 version 2.1 as both a client and server platform with the following network software: o IBM LAN Server version 2.0 (Entry System) or version 3.0 o Novell NetWare Requester for OS/2 version 2.01 In addition, SQL Server is supported as a client with the LAN Manager 2.1 Productivity Pak, and with LAN Manager 2.2, which supports OS/2 2.1 clients. With the appropriate network configuration, SQL Server on OS/2 2.1 is interoperable with components running on OS/2 1.3. (For example, an OS/2 2.1 - based client can access SQL Server running on OS/2 1.3. Or OS/2 1.3 - , MS-DOS - , or Microsoft Windows - based clients can access SQL Server running on OS/2 2.1.) MEMORY USE AND PERFORMANCE When both the computer hardware and the networking software support addressable RAM greater than 16 MB, SQL Server can take advantage of additional physical memory when running on OS/2 2.1 (Note, however, that OS/2 2.1 itself uses more memory than OS/2 1.3). For information about the ability to address greater than 16 MB of physical RAM with OS/2 2.1 in your environment, consult your hardware manufacturer or IBM. Microsoft internal testing has found that SQL Server running on OS/2 2.1 is typically slower and uses more memory than SQL Server running on OS/2 1.3. These results are from pure on-line transaction processing (OLTP) tests. The ability to address more cache memory might be more useful for query- intensive applications operating against very large databases. Note that your "mileage" may vary. Other Considerations When Running on OS/2 2.1 When considering running SQL Server on OS/2 2.1, be aware of the following considerations (note that this information is based on internal testing by Microsoft and is subject to change as newer releases of components are made available): o There is no separate version of SQL Server for OS/2 2.1. SQL Server 4.2 is compatible with both OS/2 1.3 and 2.1. o When running SQL Server setup, use the "Non-LAN Manager" installation option.