SQL Server 2000 Service Pack 3a
|
SQL Server 2000 Service Pack 3a (SP3a) addresses specific issues discovered in SQL Server 2000 since its ship date.
Because SQL Server service packs are cumulative, SP3a includes all fixes from previously released Service Pack 1 (SP1), Service Pack 2 (SP2), and Service Pack 3 (SP3). SP3a can be applied to an original installation or to one where SP1, SP2, or SP3 was previously applied.
If you have applied SP3, you do not need to apply SP3a. SP3a is only for SQL Server users who have not applied any versions of SP3. However, you should use SP3a rather than SP3 moving forward.
SQL Server 2000 SP3a:
| • | Improves serviceability for SQL Server 2000 Evaluation Edition. SP3a enables service pack upgrades for trial software. In the past, service packs have not been applicable to trial software. |
| • | Includes a new version of Microsoft Data Access Components (MDAC) version 2.71a. This version fixes the installation of MDAC files and a memory leak. These issues are addressed in articles 814572 and 814410 in the Microsoft Knowledge Base. |
| • | Disables listening on port 1434 when networking is disabled. This provides further protection from "denial of service" attacks. |
This service pack includes the following files:
| • | Sql2ksp3.exe. Updates for database components. |
| • | Sql2kasp3.exe. Updates for Analysis Services components. |
| • | Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine (MSDE 2000). |
Note: The service pack files for SP3a have the same names as the files for SP3.
Benefits
In addition to providing the latest updates and fixes, SQL Server 2000 SP3a includes the following benefits:
| • | Serviceability improvements include:
| ||||||
| • | Performance | ||||||
| • | Security
|
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) and SP3a
Users who have an existing instance of MSDE 2000 must know how their instance of MSDE 2000 was installed to know how to update it. In particular, you must know the original package name for your instance of MSDE 2000. To determine the original package name, see the article How To Identify Which MSI File Was Used for an Existing MSDE Installation in the Microsoft Knowledge Base.
| • | If the original package name for your instance was SqlRun01.msi through SqlRun16.msi, download the file SQL2KdeskSP3.exe to apply SP3a. |
| • | If the original package name for your instance was Sample.msi or SampleUpg.msi, see the article How To Create Patch Files for the MSDE 2000 Sample.msi File. |
| • | If your original package name indicates the instance of MSDE 2000 was installed by the Microsoft .NET SDK or Microsoft Application Center, see Microsoft Products that include MSDE 2000 for instructions. |
| • | If the product code associated with your instance of MSDE 2000 is not listed, then the instance was installed by the setup utility of an application. You cannot use SQL2KdeskSP3.exe to apply SP3 to such MSDE instances. Instead, you must get a patch file from the company who wrote the application. If the application came from a company other than Microsoft, you must contact that company for a patch file. If the application came from Microsoft, refer to Microsoft Products that include MSDE 2000 which lists the MSDE applications from Microsoft (this page will be updated with information about how to upgrade these instances of MSDE 2000). |
Download SQL Server 2000 SP3a
To download SQL Server 2000 SP3a, select your language from the drop-down list above, and then click Go.
Order SQL Server 2000 SP3a on CD
You can also order a copy of SQL Server 2000 SP3a on CD. English, French, and Spanish versions of the CD are available.
Additional Information
| • | If your computer has been infected by the Slammer worm, please follow the instructions on the PSS Security Response Team Alert page before installing SP3a. |
| • | Companies and users of Microsoft SQL Server 2000® Windows CE Edition (SQL Server CE) that have upgraded or plan to upgrade SQL Server 2000 database and publisher servers to the SP3a release should also update the server replication components on Internet Information Services (IIS) servers. |
Additional Information for Partners
Independent software vendors (ISVs) who ship software that runs on either SQL Server 2000 or MSDE 2000 should test for application compatibility with SP3a. For more information, read the Guidance for ISVs Shipping MSDE with Their Products page.
Service/solution providers (SPs) should encourage all customers running SQL Server 2000 or MSDE 2000 to install SP3a. If customers have applied SP3, they do not need to apply SP3a. SP3a is only for SQL Server users who have not applied any versions of SP3. However, customers should use SP3a rather than SP3 moving forward.
For More Information
This is the text leading up to a bulleted list of links.