Mssql2000sp4 patch description

The company's software couldn't be installed the day before yesterday, and the mssql Server ran well, but the error of database connection failure was reported when the company's software was installed. later I asked the technical director to know that sql2000 had to be patched. this is not a sp4 patch. the software is installed. the following is a summary of sp4. overview Update: Microsoft's

The company's software couldn't be installed the day before yesterday, and the mssql Server ran well, but the error of database connection failure was reported when the company's software was installed. later I asked the technical director to know that sql2000 had to be patched. this is not a sp4 patch. the software is installed. the following is a summary of sp4. overview Update: Microsoft's

The company's software couldn't be installed the day before yesterday, and the mssql Server ran well, but the company's software could not be connected to the database.TechnologyThe director knows that sql2000 had to create one.PatchOnly. This is not a sp4.PatchThe software is installed. The following section summarizes the related content of sp4.

Update information:Microsoft found a problem in the final internal version of SP4. If you enable the AWE Support feature when running SQL Server, it will be affected. This issue has no impact on the ia64 platform. On x86 and x64 systems, this issue affects only users who have enabled AWE and occupied more than 2 GB of memory (applicable only to Enterprise, Developer, and Evaluation versions ); more than half of the system's total memory is allocated to a single SQL Server instance.Users with this configuration should obtain and apply the patch specified in Article 899761 of the Microsoft Knowledge Base after upgrading to SP4.SP4 is a cumulative Service Pack that contains all patches in previous Service Pack versions, including MS03-031 security bulletins.SP4 contains the following SQL Server 2000 package:

• Database Components(Download file: SQL2000-KB884525-SP4-x86.EXE) Update 32-bit database components for SQL Server 2000, including database engine, replication, client connection components, and tools. For more information, see ReadmeSql2k32Sp4.htm
• Analysis Services components(Download file: SQL2000.AS-KB884525-SP4-x86.EXE): updates the 32-bit Analysis Services component of SQL Server 2000. For more information, see ReadmeSql2k32ASp4.htm.
• SQL Server 2000 Desktop Engine (MSDE) Component(Download file: SQL2000.MSDE-KB884525-SP4-x86.EXE): for SQL Server 2000 32-bit MSDE components:
  • Install a new MSDE instance
  • Upgrade an existing MSDE instance
  • Update the application that uses the Merge Module
  For more information, see readmesql2k32?sp4.htm
• SQL Server 2000 64-bit component(Download file: SQL2000-KB884525-SP4-ia64.EXE): updates the 64-bit database components and 64-bit Analysis Services components for SQL Server 2000. For more information, see ReadmeSql2k64Sp4.htm

System Requirements

• Supported operating systems:Windows 2000 Advanced Server; Windows 2000 Professional Edition; Windows 2000 Server; Windows Server 2003, Datacenter x64 Edition; Windows Server 2003, Enterprise x64 Edition; Windows Server 2003, Standard x64 Edition; windows Small Business Server 2003; Windows XP Home Edition; Windows XP Media Center Edition; Windows XP Professional Edition

• PC with Intel Pentium 166 MHz or higher processor (or compatible processor of equivalent performance)
• Minimum 64 mb ram (128 MB or higher RAM is recommended)
• MSDE installation requires 100 MB of available hard disk space

Description

Important:Windows NT 4.0, Windows Millennium Edition, and Windows 98 do not support SQL Server 2000 Service Pack 4.

Step 1:Download the appropriate package and corresponding readme files. Step 2:Back up all your databases. Step 3:View the corresponding readme file and install Description.

Additional information

Update information:Microsoft found a problem in the final internal version of SP4. If you enable the AWE Support feature when running SQL Server, it will be affected. This issue has no impact on the ia64 platform. On x86 and x64 systems, this issue affects only users who have enabled AWE and occupied more than 2 GB of memory (applicable only to Enterprise, Developer, and Evaluation versions ); more than half of the system's total memory is allocated to a single SQL Server instance.Users with this configuration should obtain and apply the patch specified in Article 899761 of the Microsoft Knowledge Base after upgrading to SP4.

Microsoft official download home page: http://www.microsoft.com/downloads/details.aspx? FamilyID = 8e2dfc8d-c20e-4446-99a9-b7f0109f8bc5 & displaylang = zh-cn # filelist