INF: SQL Server 2000 Service Pack 3a Synopsis

This article contains a synopsis of SQL Server 2000 Service Pack 3a (SP3a).

Microsoft SQL Server 2000 SP3a incorporates changes to SQL Server 2000 Service Pack 3 that address issues raised by the Slammer worm:

• To help protect SQL Server Evaluation editions, apply SQL Server 2000 Service Pack 3a. Note: You cannot install previous service packs on the Evaluation edition.
• The SQL Server Desktop Engine (also known as MSDE 2000) SP3a Setup utility now defaults to turning off support for network connections when installing new instances of MSDE 2000. The current network support settings are retained when instances are upgraded to SQL Server 2000 SP3a.
• When an instance of SQL Server 2000 SP3a or MSDE 2000 SP3a is configured not to support network connections, the instance also stops using UDP port 1434.

SQL Server 2000 SP3a also addresses some setup issues that you might experience with the version of Microsoft Data Access (MDAC) components that is in SQL Server 2000 Service Pack 3 (SP3).

Because most of the changes introduced in SQL Server 2000 SP3a are related to setup, you do not have to apply SQL Server 2000 SP3a to instances of SQL Server 2000 or MSDE 2000 that have already been upgraded to SQL Server 2000 Service Pack 3 (SP3). However, if you have instances that have not been upgraded to Microsoft SQL Server 2000 SP3 yet, you must upgrade those instances to SQL Server 2000 SP3a instead of SQL Server 2000 SP3.

If you have any copies of the SQL Server 2000 SP3 download files that you were planning to use for future upgrades, you must delete those copies and use either the SQL Server 2000 SP3a download files or the SQL Server 2000 SP3a CD-ROM instead. Applications that distribute and install MSDE 2000 must install SQL Server 2000 SP3a instead of SQL Server 2000 SP3.

While you can apply SQL Server 2000 SP3a to instances of SQL Server 2000 SP3 or MSDE 2000 SP3, doing so has little effect on those instances.

Important Note: If you have applied a post SQL Server 2000 SP3-hotfix, you must reinstall that hotfix after you install SQL Server 2000 SP3a. SQL Server 2000 SP3a might regress any post SQL Server 2000 SP3 fixes or files to their original SQL Server 2000 SP3 versions.

This release of SQL Server 2000 SP3a is provided in three parts:

• Database Components SP3a provides updates for the database components of an instance of SQL Server 2000, not including instances of the SQL Server 2000 Desktop Engine. Database Components SP3a includes updates to:
  • The database engine.
  • All the database client tools and utilities such as SQL Server Enterprise Manager, and the osql utility.
  • Database client connectivity components, such as the Microsoft OLE DB provider for SQL Server 2000, the SQL Server 2000 ODBC driver, and the client Net-Libraries.

• Analysis Services SP3a provides updates for the SQL Server 2000 Analysis Services components of a SQL Server 2000 installation, including:
  • Analysis Services.
  • Analysis Services client components that include Analysis Manager, and the Microsoft OLE DB provider for Analysis Services.
  • Database client connectivity components, such as the Microsoft OLE DB provider for SQL Server 2000, the SQL Server 2000 ODBC driver, and the client Net-Libraries.

• Desktop Engine SP3a provides updates for the database components of an instance of SQL Server 2000 Desktop Engine (MSDE 2000), including:
  • The database engine.
  • The database command prompt utilities that come with MSDE 2000, such as the osql and the bcp utilities.
  • Database client connectivity components, such as the Microsoft OLE DB provider for SQL Server 2000, the SQL Server 2000 ODBC driver, and the client Net-Libraries.

These three parts of SQL Server 2000 SP3a can be applied individually, as follows:

• SQL Server 2000 sites can use Database Components SP3a to upgrade their database components, without upgrading their Analysis Services components or instances of the SQL Server 2000 Desktop Engine.
• Analysis Services 2000 sites can use Analysis Services SP3a to upgrade their Analysis Services components, without upgrading instances of Desktop Engine, or their database components.
• MSDE 2000 sites can use Desktop Engine SP3a to upgrade instances of MSDE 2000, without upgrading Analysis Services, or instances of the SQL Server 2000 database engine.

If separate instances of both MSDE 2000 and other editions of the SQL Server 2000 database engine are installed on the same computer, you must apply Desktop Engine SP3a to instances of MSDE 2000, and Database Components SP3a to instances of the SQL Server 2000 database engine, such as Personal Edition, Standard Edition, or Enterprise Edition.

Desktop Engine SP3a is the only part of the service pack that is available in Portuguese (Brazil), Swedish, and Dutch, because SQL Server 2000 Desktop Engine (MSDE 2000) is the only version of SQL Server 2000 that is produced for those languages. The SQL Server 2000 components upgraded by Database Components SP3a or Analysis Services SP3a are not available in those languages. Portuguese (Brazil), Swedish, and Dutch users who want to apply SQL Server 2000 SP3a to a version of SQL Server other than Desktop Engine, must download the SQL Server 2000 SP3a files that match the language of the edition they want to upgrade. For example, English-language SQL Server 2000 SP3a files must be downloaded to upgrade the English-language version of the SQL Server 2000 database engine.

For more information about how to download the service pack, visit the following Microsoft Web site:

SQL Server 2000 Service Pack 3a (http://technet.microsoft.com/en-us/sqlserver/bb331729.aspx)

How to Identify Your Version of SQL Server or Analysis Services

Use these techniques to determine what version of SQL Server or Analysis Services you have installed.

SQL Server

To identify what version of the SQL Server 2000 database engine or the MSDE 2000 you have installed, type the following command at the command prompt by using either the osql or the isql utility or by using the Query window in SQL Query Analyzer:

SELECT @@VERSION or SERVERPROPERTY('ProductVersion')

Similarly, you can determine the product level for a particular version of the SQL Server 2000 database engine or MSDE 2000 by running this command:

SELECT SERVERPROPERTY('ProductLevel')

The following table shows the relationship between:

• The SQL Server 2000 version and level.
• The version number reported by @@VERSION.
• The product level reported by SERVERPROPERTY('ProductLevel').

If you are not sure what edition of the SQL Server 2000 database engine or MSDE 2000 you are running, view the last line of output returned by SELECT @@VERSION. The last line will match one of the following:

• Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 2)
• Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
• Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
• Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
• Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
• Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

Note The beginning of the line indicates the edition of the SQL Server database engine or MSDE 2000. This is followed by current operating system information.

You can also determine the edition by typing SELECT SERVERPROPERTY('Edition') at the command prompt by using either the osql or the isql utility, or by using the Query window in SQL Query Analyzer.

Analysis Services

To identify what version of Analysis Services you have installed, follow these steps:

1. From the Start menu, point to Program Files, point to SQL Server 2000, point to Analysis Services,, and then click Analysis Manager.
2. In the Analysis Manager tree, right-click the Analysis Servers node, and then click About Analysis Services.
3. Use this table to determine what version of Analysis Services you have:

How to Distinguish Between SQL Server 2000 SP3 and SQL Server 2000 SP3a

To determine whether you have SQL Server 2000 SP3 or SQL Server 2000 SP3a installed, check the version number of the Net-Library file, Ssnetlib.dll. If the version number of this file is 2000.80.760.0, you have SQL Server 2000 SP3. If the version number of this file is 2000.80.766.0, you have SQL Server 2000 SP3a.

Assuming that an instance was installed by using the default settings, you can find the Ssnetlib.dll file in one of these locations:

• Default instance: C:\Program Files\Microsoft SQL Server\Binn\Ssnetlib.dll
• Named instance: C:\Program Files\Microsoft SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll

To find out whether you have the SQL Server 2000 SP3 or SQL Server 2000 SP3a setup folders, open the SP3Readme.htm file. The service pack version, SQL Server 2000 SP3a or SQL Server 2000 SP3, is listed at the top of the first page.

For additional information about SQL Server 2000 SP3a, visit the following Microsoft Web sites:

SQL Server 2000 SP3a Readme.htm (http://support.microsoft.com/kb/889551)