MORE INFORMATION
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 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').
|
| SQL Server 2000 Original
Release | 8.00.194 | RTM |
| Database Components SP1 or Desktop Engine
SP1 | 8.00.384 | SP1 |
| Database Components SP2 or Desktop Engine
SP2 | 8.00.534 | SP2 |
| Database Components SP3 or SP3a, or Desktop Engine SP3 or
SP3a | 8.00.760 | SP3 |
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:
- From the Start menu, point to
Program Files, point to SQL Server 2000,
point to Analysis Services,, and then click Analysis
Manager.
- In the Analysis Manager tree, right-click
the Analysis Servers node, and then click About
Analysis Services.
- Use this table to determine what version of Analysis
Services you have:
|
| SQL Server 2000 Analysis Services Original
Release | 8.0.194 |
| Analysis Services SP1 | 8.0.382 |
| Analysis Services SP2 | 8.0.534 |
| Analysis Services SP3 or SP3a | 8.0.760 |
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.