Secure installation of microsoft sql server 2000

Microsoft Squốc lộ Server 2000 Enterprise Edition English - 1 Processor License . Microsoft Windows Server Standard 2012 R2 64 Bit English DVD 10 Clt. You need one for each processor in the computer, & instead of using hệ thống license"s, processor license"s give sầu you. Books With Free.

Bạn đang xem: Secure installation of microsoft sql server 2000


Describes how khổng lồ obtain the SP4 installation files. Prepare an instance for tăng cấp to SP4. Details the preparatory steps lớn take before you install SP4.
Install SP4. Details options for running SP4 cài đặt. Squốc lộ Server 2000 SP4 has four parts:. SQL Server 2000 SP4 (64-bit) includes all updates for Squốc lộ Server 2000 (64-bit). cảnh báo This is the first service pachồng for SQL Server 2000 (64-bit). Database Components SP4 updates an instance of the database engine for Squốc lộ Server 2000 (32-bit) Enterprise Edition, Standard Edition, Developer Edition, Enterprise Evaluation Edition, or Personal Edition.
Analysis Services SP4 updates the various parts of SQL Server 2000 (32-bit) Analysis Services in a SQL Server 2000 installation. MSDE 2000 SP4 updates instances of Squốc lộ Server 2000 MSDE 2000 và MSDE 2000 Release A. This service pack cannot be used to tăng cấp any 32-bit SQL Server 2000 components. To upgrade 32-bit components of SQL Server 2000, you must obtain the other parts of SP4, which nâng cấp Squốc lộ Server 2000 Database Components, Squốc lộ Server 2000 Analysis Services và Squốc lộ Server 2000 Desktop Engine. Separate Readme files describe how to install these 32-bit components of SP4.
The 32-bit components & the Readme files are available at this. 1.1 System Requirements This section describes changes lớn system requirements và system related issues that affect the installation of SQL Server 2000 SP4 (64-bit). General information on system requirements for Squốc lộ Server 2000 (64-bit) can be found at this. Installation Issues on Supported Systems SP4 fails khổng lồ install on an instance of SQL Server 2000 (64-bit) Database Components if the Devices: Unsigned driver installation behavior local security policy for Windows Server 2003 has been phối khổng lồ Do not allow installation. If you use the Do not allow installation setting, you must change it to lớn Silently succeed before you install SP4. If necessary, you can return the policy to lớn its previous setting after the installation is complete. cảnh báo Do not allow installation is not the default setting for these security policies.

To phối security policies. In Control Panel, double-click Administrative Tools. Double-clichồng Local Security Policy. Expand Local Policies. Select Security Options. Ensure that the Devices: Unsigned driver installation behavior option in the right pane is set to Silently Succeed before you install SP4: Application Requirements If your instance of SQL Server 2000 (64-bit) is being used by an application, before you upgrade khổng lồ SP4, ask the provider of the application whether any SQL Server 2000 nâng cấp considerations apply to lớn that application.
1.2 Before You Upgrade to lớn SP4 You can apply SP4 to lớn one or more instances of Squốc lộ Server 2000 (64-bit). 1.2.1 Determine How lớn Remove Database Components SP4 Before you use SP4 to nâng cấp an existing instance of Squốc lộ Server 2000, it is advisable lớn plan how to return the instance to its previous state, in case that becomes necessary later. When Squốc lộ Server 2000 SP4 is installed, it makes changes to the system tables for maintenance purposes. It also upgrades user và distribution databases that are members of a replication topology. Because of the nature of these changes, SP4 cannot be removed easily. To revert khổng lồ the build that you were running before you installed SP4, you must first uninstall the instance of the SQL Server 2000 (64-bit) database engine và then reinstall that instance.
Second, if you applied any hotfixes, you must reapply the hotfixes lớn the instance that is being reverted. Important To restore your system safely to its pre-SP4 state, you must have sầu made backups of the master, model, and msdb databases immediately before you installed SP4. For more information, see Section 3.1. For more information, see Section 3.2.
1.2.2 Determine How to lớn Remove sầu Analysis Services SP4 Before you use Analysis Services SP4 to nâng cấp an existing instance of Analysis Services, it is advisable to plan how to return the instance lớn its previous state, in case that becomes necessary later. To revert khổng lồ the build that you were running before you installed Analysis Services SP4, you must first uninstall the instance of Analysis Services SP4 & then reinstall that instance of Analysis Services. Second, if you ran a previous Squốc lộ Server 2000 service pachồng or applied any hotfixes, you must reapply the service paông xã and hotfixes lớn the instance that is being reverted.
To prepare for a later return khổng lồ pre-SP4 Squốc lộ Server Analysis Services, you must bachồng up the registry key HKLOCALMACHINE Software Microsoft OLAP. Server & all of its subkeys before you install Analysis Services SP4. When you later uninstall Analysis Services SP4, you must delete this registry key & restore the pre-SP4 version from the backup.
For more information, see Section 3.7. 1.2.3 Upgrade an Instance in a Replication or Log Shipping Topology SQL Server 2000 SP4 Setup upgrades user databases that are members of a replication topology. This nâng cấp factor can affect backup-and-restore functionality of replicated user databases.
Before you install SQL Server 2000 (64-bit) SP4, ensure that replication databases & filegroups are writable và that the user trương mục that is running Setup has permission lớn access the databases. For more information about applying SP4 to databases that are included in replication topologies, see Section 3.5. If SP4 Setup detects user databases or filegroups that are not writable, it does the following:. Applies the SP4 replication updates lớn all writable user databases.
Writes a list of the non-writable databases lớn the Setup log, which is located at WINDOWS Hotfix hotfix.log. Displays the following warning message: Setup has detected one or more databases & filegroups which are not writable.
You can ignore this warning unless some of the databases listed in the Setup log are members of a replication topology. If any of the non-writable databases listed in the Setup log are members of a replication topology, you must make those databases writable & reapply SP4 Setup lớn that instance of SQL Server 2000 (64-bit). lưu ý This message does not affect unattended installations. For more information about unattended installations, see Section 4.1.
For more information about making a database writable, see Section 3.6. For more information about reapplying SP4, see Section 3.8. You need not remove log shipping before you tăng cấp lớn SP4. However, if the database log is shipped to a database that is a replication Publisher, you must vì the following:.
Take the database offline before you apply SP4. Apply SP4 to the instance. Bring the database baông chồng online.
Run the following script: USE master GO EXEC spvpupgradereplication GO If you apply SP4 without having taken offline all non-writable databases that ship logs lớn publication databases, you receive sầu this error: Error Running Script spvpupgradereplication (1) If you receive sầu this error, follow the preceding procedure. cảnh báo During installation, Setup makes no distinction between read-only databases and databases that are offline or in a suspect state. If a replication database or filegroup is in any of these conditions during thiết đặt and is involved in a replication topology, you must reapply the service paông chồng after making the database writable.
1.3 Identify the Current Version of Squốc lộ Server 2000 Before running Setup, identify the versions of the instances of Squốc lộ Server 2000 (64-bit) that is being upgraded. The method for determining which version of SQL Server 2000 (64-bit) is installed depends on whether you have sầu a database engine or Analysis Services installation.
To identify the installed version of Squốc lộ Server 2000 (64-bit) Database Components:. Execute one of the following queries against an instance of the database engine by using isql, osql, or Query Analyzer:. SELECT SERVERPROPERTY("ProductLevel"). SELECT
VERSION Product Level Database Components (64-bit) Original Release 8.00.760 RTM Database Components (64-bit) SP4 8.00.2039 SP4 chú ý Your sản phẩm version may be different than these values if you applied a hotfix after installing the hàng hóa or after installing a previous service paông xã.
VERSION returns a value of 8.00.818 after you apply the security fix MS03-031 to lớn SQL Server 2000 (64-bit). 1.4 Additional Information About SP4 A danh sách of the fixes contained in this service paông xã will be provided in Microsoft Knowledge Base articles and. Each fix listed in these articles has a links lớn a Knowledge Base article describing the problem addressed by the fix. Follow the links to the individual Knowledge Base articles lớn see information about each fix. Any information relevant to Squốc lộ Server 2000 Service Paông xã 4 that was not available in time khổng lồ be included in this Readme tệp tin will be published in Microsoft Knowledge Base article. The Knowledge Base articles mentioned in this Readme are available in the. Under Advanced Search, in the For text box, type the number of the article you want.
From the Select a Microsoft Product drop-down danh sách, select Squốc lộ Server 2000. Under Search Type, select Article ID. Cliông xã the Run the search right-arrow button. Hotfixes All publicly issued Squốc lộ Server 2000 (64-bit) security bulletins have sầu been addressed in SP4. If you received a Squốc lộ Server 2000 hotfix after December 2, 2004, that hotfix is unlikely to lớn be included in SP4. Contact your primary support provider about obtaining the same hotfix for SQL Server 2000 SP4. Squốc lộ Server 2000 SP4 includes serviceability enhancements that enable you lớn uninstall future hotfixes.
cảnh báo Even if you updated your hệ thống replication components after you upgraded lớn SQL Server 2000 SP3 or SP3a, you must install the lathử nghiệm SP4-specific updates to VPS tools components. OPENXML Update SQL Server 2000 SP4 (64-bit) now uses the same internal version of the MSXML giải pháp công nghệ that is used by 32-bit versions of SQL Server 2000 SP4. This change removes the dependency that Squốc lộ Server 2000 (64-bit) had on the version of MSXML 3.0 installed by the operating system. 2.0 Where to Find & Download SQL Server 2000 SP4 (64-bit) Before you prepare to download and extract Squốc lộ Server 2000 SP4, read "Downloading and Extraction Phase Guidelines," later in this section. Squốc lộ Server 2000 SP4 is distributed in the following ways:.
On a SQL Server 2000 Service Pachồng 4 CD-ROM that contains service packs for the following components:. Squốc lộ Server 2000 SP4 (64-bit). Database Components SP4. Analysis Services SP4. MSDE 2000 SP4 If you have sầu an SP4 CD, you can tăng cấp an instance of Squốc lộ Server 2000 (64-bit) khổng lồ SP4 by using the self-extracting file SQL2000-KB884525-SP4-ia64- LLL.exe pháo from the CD. In four self-extracting installation package files that can be downloaded from the Internet at this:.
SQL2000-KB884525-SP4-ia64- LLL.exe (SQL Server 2000 SP4 (64-bit)). SQL2000-KB884525-SP4-x86- LLL.exe (Database Components SP4).
SQL2000.AS-KB884525-SP4-x86- LLL.exe (Analysis Services SP4). SQL2000.MSDE-KB884525-SP4-x86- LLL.exe pháo (Desktop Engine (MSDE 2000) SP4) Note LLL represents a designator that varies by language. After you have acquired SQL2000-KB884525-SP4-ia64- LLL.exe pháo from either the download site or SP4 CD, you can then run it to lớn extract the Squốc lộ Server 2000 SP4 (64-bit) files onkhổng lồ your computer. SQL2000-KB884525-SP4-ia64- LLL.exe creates a phối of folders and files on your hard disk that you can use khổng lồ install Squốc lộ Server 2000 SP4 (64-bit). 2.1 Choosing the Correct Language Squốc lộ Server 2000 service packs are language-specific.
To upgrade an instance of SQL Server 2000 (64-bit), you must obtain the service pack that has the same language as your instance. You get the service paông chồng either on a SQL Server 2000 SP4 CD or by downloading the SP4 files. For example, if you upgrade an instance of SQL Server 2000 (64-bit) that uses Japanese, you must download the Japanese version of SP4. If you are unsure of the language of an instance of SQL Server 2000 (64-bit):. Click Start, then cliông chồng Run. In the xuất hiện box, type Regedit, then cliông xã OK.
Locate and select one of the following keys:. For a mặc định instance of SQL Server 2000, locate and select this subkey: HKEYLOCALMACHINE SOFTWARE Microsoft MSSQLServer MSSQLServer CurrentVersion. For a named instance of SQL Server 2000, locate & select this subkey: HKEYLOCALMACHINE SOFTWARE Microsoft Microsoft Squốc lộ Server InstanceName CurrentVersion where InstanceName is the name of the instance. In the right các mục pane, read the value of the Language entry. Compare that value to lớn those in the following table khổng lồ determine the language for your instance of Squốc lộ Server 2000: Language Registry value (in hexadecimal) Language Registry value (in decimal) Language of That Instance 0x000 German 0x000 English 0x0000040c 1036 French 0x000 Japanese 2.2 Downloading SQL Server 2000 SP4 (64-bit) To download the self-extracting installation package for SQL Server 2000 SP4 (64-bit):. Go lớn this.
From the Full Download drop-down danh sách in the upper-right portion of this page, select the language that matches the language for your instance of Squốc lộ Server 2000, and click Go. On the Microsoft Download Center page that corresponds khổng lồ the language chosen, select the file SQL2000-KB884525-SP4-ia64- LLL.exe pháo, where LLL varies by language. 2.3 Extracting the Database Components SP4 Files You must first extract the installation files from SQL2000-KB884525-SP4-ia64- LLL.exe before you can install Database Components SP4 (64-bit). You can exedễ thương SQL2000-KB884525-SP4-ia64- LLL.exe directly from the SP4 CD, or from the thư mục into which you either downloaded it or copied it from the CD. To extract the Database Components SP4 (64-bit) files:. xuất hiện Windows Explorer và navigate khổng lồ the thư mục that contains SQL2000-KB884525-SP4-ia64- LLL.exe. Double-clichồng SQL2000-KB884525-SP4-ia64- LLL.exe cộ khổng lồ extract the Database Components SP4 (64-bit) files.
When asked, specify the thư mục into which you want the SP4 files khổng lồ be extracted. 2.4 Download and Extraction Phase Guidelines When you download & extract SP4 installation files from the Internet, use the following guidelines:.
When running SQL2000-KB884525-SP4-ia64- LLL.exe cộ lớn place the SP4 files inlớn a thư mục, make sure you have không tính phí space that is approximately three times the size of the executable tệp tin in order khổng lồ extract và store the service pack installation files. You must have sầu space enough khổng lồ store the self-extracting file and the extracted service paông xã files, & temporary working space for the self-extraction program. When you tải về SQL2000-KB884525-SP4-ia64- LLL.exe cộ to your local or shared directory, & run the tệp tin, SQL2000-KB884525-SP4-ia64- LLL.exe prompts you for the name of the folder inkhổng lồ which you want the service paông chồng files placed. chú ý When you extract the service paông xã to lớn a network shared directory, the path to lớn the thư mục that you specify is relative sầu to the thư mục in which you ran SQL2000-KB884525-SP4-ia64- LLL.exe cộ.
You can rename or move sầu the thư mục after extracting the components. However, make sure that the folder path name does not contain blank spaces.
You can download all four SP4 self-extracting files và extract them into the same target folder to create a location from which you can install each part of SQL Server 2000 SP4. The four self-extraction files will not overwrite each other or interfere with each other.
2.5 SP4 Setup Documentation SP4 installation files contain updated thiết lập documentation that you can access by clicking Help during SP4 thiết đặt. This documentation does not update the version of Squốc lộ Server 2000 (64-bit) Books Online that is already installed on your computer. To access the updated SQL Server 2000 (64-bit) SP4 setup documentation, run the Setupsql.chm tệp tin. Setupsql.chm is located in the root thư mục on the SP4 CD-ROM, the local thư mục, or the network nói qua that contains the extracted service paông xã files.
lưu ý Updated Books Online documentation for Squốc lộ Server 2000 (32-bit) is available as a set of downloadable files at this. 3.0 Service Pachồng Installation To install SQL Server 2000 SP4 (64-bit), follow the instructions in this section. Reviews the material in Section 1.0 before installing SP4.
The steps khổng lồ install SP4 are:. 3.1 Prepare for SP4 Installation You must bởi the following before you install SP4:. 3.1.1 Back Up Your Squốc lộ Server Databases Before you install SP4, bachồng up the master, msdb, & model databases.
Installation of SP4 modifies the master, msdb, and model databases, making them incompatible with pre-SP4 versions of Squốc lộ Server. Backups of these databases are required if you decide to lớn reinstall Squốc lộ Server 2000 (64-bit) without SP4. It is also advisable to baông xã up your user databases, although SP4 performs updates only on user databases that are members of replication topologies. 3.1.2 Baông xã Up Your Analysis Services Databases, Repository, và Registry Settings Before you install SP4 to nâng cấp an instance of Analysis Services, baông chồng up your Analysis Services databases by making a copy of the Microsoft Analysis Services Data folder, which is installed by default under the C: Program Files thư mục. Baông xã up the database that contains the repository before installing SP4, which by default is located at C: Program Files Microsoft SQL Server MSSQL$instancename Data OLAPRepository.mdf, where $InstanceName specifies the instance name for a named instance of Squốc lộ Server 2000 (omitted for the default instance). Also, save your Analysis Server registry entries. To back up registry settings on a computer running on Windows 2000:.
Run Regedit.exe. Locate the subkey HKEYLOCALMACHINE SOFTWARE Microsoft OLAPhường Server. Select the Export Registry File vật phẩm on the Registry menu. Specify a name and location for the exported registry file.
To bachồng up registry settings on a computer running on Windows XPhường. or Windows 2003 Server:. Run Regedit.exe pháo. Locate the subkey HKEYLOCALMACHINE SOFTWARE Microsoft OLAP.. Server. Select the Export cửa nhà on the File thực đơn.
Specify a name and location for the exported registry file. If you have sầu migrated your Analysis Services repository lớn Squốc lộ Server, back up the database that contains the repository before you install SP4. For more information, see Section 3.7.
3.1.3 Verify that the System Databases Have sầu Enough Free Space If the autogrow option is not selected for the master and msdb databases, the databases must have at least 500 kilobytes (KB) of không tính tiền space. To verify that they have this much space, run the spspaceused system stored procedure for the master or msdb database. If the unallocated space in either database is less than 500 KB, increase the form size of the database. For more information, see "Expanding a Database" in Squốc lộ Server Books Online. If the autogrow option is selected for the master và msdb databases, & there is sufficient room on the drives, you can skip the preceding space-verification step.
To verify that the autogrow option is selected in SQL Server 2000, open Squốc lộ Server Enterprise Manager on a 32-bit computer, connect khổng lồ the 64-bit instance of SQL Server lớn tăng cấp, right-click the inhỏ for the database, and then cliông xã Properties. Verify that the Automatically grow tệp tin kiểm tra box is selected. 3.1.4 Verify that the Service Accounts Are Not Disabled Setup may fail if the service startup type for the MSSQLServer and MSSQLServerOLAPService services are phối to Disabled. To verify & enable service accounts. In Control Panel, select Administrative Tools, then Services.
Locate the MSSQLServer service in the menu & note the value for Startup Type. If the value for Startup Type is Disabled, double-clichồng the service name và change Startup Type to either Manual or Automatic. Repeat steps 2 & 3 for the MSSQLServerOLAPService service. 3.1.5 Stop Services và Applications Before You Run SP4 Setup You should stop all applications & services that make connections to all instances of SQL Server being upgraded, including Control Panel, Add & Remove sầu Programs, Squốc lộ Server 2000 Reporting Services, Squốc lộ Server 2000 Notification Services, before installing SP4. You can apply SP4 without first shutting down applications and services. Setup will stop the MSSQLServer, SQLServerAgent, & MSSQLServerOLAPService services.
If Setup determines that other applications and services must be stopped, a warning dialog box will be displayed that lists the applications và services that must be stopped. After you stop these applications and services, cliông chồng Try Again. If you cannot stop an application or service, cliông xã Continue.
Setup will continue, but you may need lớn restart your computer after Setup is complete. If you clichồng Cancel, Setup will be cancelled. Setup may stop Squốc lộ Server Service Manager. If this occurs you may need khổng lồ restart Squốc lộ Service Manager after Setup is complete. chú ý Setup cannot always determine which applications & services must be stopped.

Xem thêm: 27/9 Là Cung Gì ? Ngày 27/9 Là Cung Gì


You can reduce the likelihood that you will need to lớn restart your computer after you install Squốc lộ Server SPhường. (64-bit). To reduce this likelihood, you should stop all applications và services that make connections lớn SQL Server (64-bit), including Control Panel, before installing SP4.
You cannot stop the services in a clustered environment. For more information, see Section 3.4. 3.2 Install SQL Server 2000 SP4 (64-bit) To install Squốc lộ Server 2000 SP4 (64-bit), run Setup.exe pháo from one of the following locations:.
The thư mục on the local computer that contains the extracted service paông xã files from SQL2000-KB884525-SP4-ia64- LLL.exe cộ, where LLL varies by language. The folder on the network giới thiệu that contains the extracted service pachồng files from SQL2000-KB884525-SP4-ia64- LLL.exe cộ. This starts the setup installation process. SP4 (64-bit) supports unattended installation. For more information, see Section 4.1 Installation Process Depending on the options selected, the following installation dialog boxes are displayed during setup:.
Welcome — Provides an overview of Setup. EULA — You must accept the end-user license agreement (EULA). Instance khổng lồ Update — Allows you to lớn select SQL Server 2000 (64-bit) instances to update. Authentication Mode — You must choose the authentication mode that Setup uses when connecting khổng lồ SQL Server. When possible, select Windows Authentication. If you select SQL Server Authentication, you must supply the password for the sa account. To use different authentication modes or to lớn specify different sa passwords for individual Squốc lộ Server 2000 (64-bit) instances, click the Advanced option button, select an instance from the list, và then click Edit to lớn select the authentication mode for that instance.
Error Reporting — If error reporting is disabled for at least one instance of Squốc lộ Server 2000 (64-bit), the error reporting dialogue is displayed. To enable error reporting, select the check box Enable Squốc lộ Server error reporting. This enables error reporting for all instances.
For more information, see Section 5.4.1. Ready to lớn Install — Setup has all the information it needs to begin the installation. Installation Progress — Reports ongoing status for each instance being updated. Installation Complete — Reports the final status of each updated instance. This page includes a links khổng lồ the log file ( HotFix.log).
3.3 Restart Services và Applications When Setup completes, it may prompt you lớn restart the computer. Section 3.1.3 provides guidelines on when a restart is required. After the system restarts (or after Setup completes without requesting a restart), use the Services application in Control Panel khổng lồ make sure that any services you stopped before applying the service pachồng are now running. This includes services such as DTC & the Microsoft Search services or their instance-specific equivalents. Restart the applications you closed before running the service pachồng Setup program. It is prudent lớn also bachồng up the upgraded master, msdb, & Mã Sản Phẩm databases at this time. 3.4 Install on a Failover Cluster The following information applies only lớn SQL Server 2000 (64-bit) components that are part of a failover cluster.
To install the service paông xã on a failover cluster. If any resources have sầu been added with dependencies on SQL Server resources, those dependencies must either be removed or taken offline before you install SP4. If you bởi not remove the dependencies, the installation of SP4 will take those resources offline. Note When a clustered resource is taken offline, all dependent resources are also taken offline by the cluster service. Run the service paông xã from the node (active node) that owns the group containing the virtual VPS that you plan lớn nâng cấp.
This installs the service paông chồng files on all nodes in the failover cluster. You cannot install SP4 on any other nodes (passive sầu nodes) in the cluster. In the Instance to Update dialog box, select the virtual VPS that you plan to lớn nâng cấp. Setup prompts you for login credentials used to lớn connect lớn other nodes in the cluster. Keep all nodes of the cluster online during thiết đặt. This ensures that the nâng cấp is applied to lớn each node of the cluster.
If you removed dependencies or took resources offline in Step 1, restore the dependencies or bring the resources online. Note Setup might require restarting of the failover cluster nodes. This restart replaces the files that were in use during setup with the updated files. For additional information about how to install SP4 on a failover cluster, see Knowledge Base article. For an example of how khổng lồ install SP4 in unattended mode with remote authentication for failover clusters, see 4.1. If you need to lớn rebuild a node in the failover cluster, persize the following steps.
Rebuild the node in the failover cluster. For more information about rebuilding a node, see "How to recover from failover cluster failure in Scenario 1" in SQL Server 2000 Books Online (64-bit). Run the original Squốc lộ Server 2000 (64-bit) Setup program to lớn restore the node to lớn the failover cluster. Run SP4 Setup on the node you have added. 3.5 Install on Replicated Servers The following information applies only khổng lồ existing instances of SQL Server 2000 that are part of a replication topology:. Before you upgrade khổng lồ SP4, ensure that the Windows trương mục on which the SQL Server service runs is a thành viên of the sysadmin fixed VPS role. You must verify this because replication distribution databases are upgraded under the context of the SQL Server service trương mục.
After upgrading to lớn SP4, you should remove sầu the Windows tài khoản from the sysadmin role. You must upgrade the Distributor before you tăng cấp the quảng cáo online lưu ý In many cases, especially in merge replication, the Distributor & Publisher are on the same VPS and are upgraded at the same time. When you need lớn tăng cấp an instance of Squốc lộ Server 2000 in replication topologies based on transactional replication with read-only Subscribers, you can tăng cấp the Subscriber before or after the Publisher and Distributor.
When you need khổng lồ nâng cấp an instance of SQL Server 2000 in replication topologies that are based on merge replication or transactional replication with updating Subscribers, you must upgrade the Subscriber after the Publisher và Distributor. If you use merge replication & the Distributor is located on another computer or database instance (a remote Distributor), after applying SP4 you must generate a new snapshot. Installing SP4 on a Server that Acts as a Advertiser và a Subscriber You might need lớn quiesce the system (stop all updates) & nâng cấp all servers simultaneously in the following cases. For replication topologies based on merge replication. For replication topologies based on transactional replication, which updates Subscribers, aước ao which are one or more servers that act as both a Subscriber và a Advertiser (or Distributor). Example 1: Topology That Requires Simultaneous Upgrades The following table includes servers that both publish and subscribe to lớn publications that allow updates at the Subscriber.
As noted earlier, you must follow the tăng cấp order Distributor, Publisher, Subscriber for topologies that allow updates at the Subscriber. This order requires you to lớn upgrade Server A first for the merge publication and Server B first for the transactional publication with updating Subscribers. In this case, you must quiesce the system & tăng cấp the servers simultaneously. Server A Server B Publisher/Distributor for merge replication Subscriber for merge replication Subscriber for transactional replication with updating Publisher/Distributor for transactional replication with updating Example 2: Topology That Allows Sequential Upgrades In this example, you can tăng cấp Server A first because the read-only transactional publication allows a Subscriber to lớn be upgraded before the Publisher/Distributor. Server A Server B Publisher/Distributor for merge replication Subscriber for merge replication Subscriber for read-only transactional replication Publisher/Distributor for read-only transactional replication 3.6 Apply SP4 khổng lồ Read-Only Databases or Filegroups in a Replication Topology The following information applies only lớn Squốc lộ Server 2000 (64-bit) instances that are part of a replication topology. When non-writable databases or filegroups exist, Setup displays the following message: Setup has detected one or more databases and filegroups which are not writable.
In general, you can ignore this warning và thiết đặt will continue. However, if any of the non-writable databases listed in the Setup log are members of a replication topology, you must make those databases writable và reapply SP4 Setup to that instance of SQL Server 2000. cảnh báo This message does not affect unattended installations.
For more information about unattended installations, see Section 4.1. During installation, Setup makes no distinction between non-writable databases và databases that are offline or in a suspect state. If a database or filegroup in a replication topology is non-writable, you must reapply the service pack lớn nâng cấp this database. For more information about bringing a database online, see the topic "Attaching và Detaching a Database" in Squốc lộ Server Books Online. For more information about diagnosing suspect databases, see the topic "Server và Database Troubleshooting" in Squốc lộ Server Books Online. To apply SP4 to a read-only database. Make the read-only database writable by using the ALTER DATABASE statement, as follows: ALTER DATABASE database SET READWRITE.
Repeat Step 1 for all read-only databases. Apply (or reapply) the service pack. If required, make the database read-only again by using ALTER DATABASE, as follows: ALTER DATABASE database SET READONLY To apply SP4 khổng lồ a read-only filegroup. Make the read-only filegroup writable using ALTER DATABASE, as follows: ALTER DATABASE Database MODIFY FILEGROUP filegroupname READWRITE. Repeat Step 1 for all read-only filegroups. Apply (or reapply) the service paông chồng.
Make the filegroup read-only again using ALTER DATABASE, as follows: ALTER DATABASE Database MODIFY FILEGROUP filegroupname READONLY For more information about ALTER DATABASE, see the ALTER DATABASE reference topic in Squốc lộ Server Books Online. For more information about reapplying SP4, see Section 3.8. 3.7 Uninstall SP4 To remove sầu Database Components SP4, follow the instructions in this section. To be able lớn return lớn pre-SP4 versions of Squốc lộ Server 2000 components, you must back up the master, msdb, và mã sản phẩm databases before you install SP4.
For more information, see Section 3.1. If any of the databases are involved in replication, you must disable publishing. To disable publishing:. In Squốc lộ Server Enterprise Manager, exp& a SQL Server group, expvà a hệ thống, right-clichồng the Replication folder, and then cliông chồng Configure Publishing, Subscribers, và Distribution. Cliông xã the Publication Databases tab. Clear the check box for each database that is involved in replication. This allows the databases lớn be detached.
To revert khổng lồ the pre-SP4 version of Squốc lộ Server. Detach all user databases. For more information, see "How khổng lồ attach và detach a database (Enterprise Manager)" in SQL Server 2000 Books Online. Uninstall Squốc lộ Server. In Control Panel, double-clichồng Add/Remove sầu Programs, và then select the instance of SQL Server that you want to lớn uninstall. Install SQL Server 2000 from the CD-ROM or the location from which you originally installed Squốc lộ Server. Apply any service packs and QFE fixes that were installed prior khổng lồ SP4.
Restore the databases master, msdb, và mã sản phẩm from the last backup that was created before applying SP4. This automatically attaches any user databases that were attached at the time the backup was created, assuming that the location of the data files has not changed. Attach any user databases that were created after the last backup of the master database.
Configure replication if necessary. Warning When you revert to lớn the pre-SP4 version of SQL Server 2000, all changes made lớn the databases master, msdb, và mã sản phẩm since applying SP4 are lost.
3.8 Reapplying SP4 The following information applies khổng lồ all components. In the following cases, you must reapply SP4:.
If new Squốc lộ Server 2000 (64-bit) components are added after SP4 is applied. If databases or filegroups that are part of a replication topology và were read-only during the initial application of SP4 are made writable.
To reapply SP4, follow the steps in Section 3.0. 4.0 Additional Installation Information This section documents additional service paông xã installation considerations that apply only in special cases.
4.1 Unattended Installations SP4 can be applied in unattended mode to lớn one or more instances of Squốc lộ Server 2000 (64-bit). Unattended setup is run from the comm& prompt by using comm& line parameters lớn specify specific cài đặt options. The /quiet parameter suppresses the Setup dialog boxes và allows unattended installation.
The following procedures show comm& prompt syntax khổng lồ install the SP4 package in typical unattended mode scenarquả táo. Modify & test these examples to meet the needs of your organization. To install SP4 in unattended mode for all qualifying instances of Squốc lộ Server 2000 (64-bit). mở cửa the command prompt window & navigate lớn the location of the SP4 cài đặt files. Type the following at the commvà prompt and press ENTER: cài đặt.exe pháo /quiet /allinstances To install SP4 in unattended mode for the default instance of Squốc lộ Server 2000 (64-bit). mở cửa the commvà prompt window & navigate to the location of the SP4 setup files.
Type the following at the commvà prompt và press ENTER: thiết đặt.exe cộ /quiet /instancename=MSSQLServer To install SP4 in unattended mode for a specified Squốc lộ Server 2000 (64-bit) instance. xuất hiện the commvà prompt window và navigate to lớn the location of the SP4 cài đặt files. Type the following at the command prompt and press ENTER: thiết lập.exe cộ /quiet /instancename= Note specifies the target instance.
To install SP4 in unattended mode for all qualifying instances of Squốc lộ Server 2000 (64-bit) on a failover cluster. Open the command prompt window and navigate to lớn the location of the SP4 setup files. Type the following at the comm& prompt và press ENTER: thiết đặt.exe cộ /quiet /allinstances /user= /password= user is the login used khổng lồ connect to lớn all nodes of the cluster, và password is the password for the specified login. Security Note If you must run an unattended clustered setup; supply the login credentials at runtime. If you must store this password in a script file, secure the tệp tin khổng lồ prsự kiện unauthorized access. To install SP4 in unattended mode using Squốc lộ Server Authentication. Open the command prompt window & navigate to the location of the SP4 cài đặt files.
Type the following at the comm& prompt & press ENTER: thiết lập.exe pháo /quiet /allinstances /sapwd= sapassword is the password for the sa trương mục. Security lưu ý If you must run an unattended cài đặt using SQL Server Authentication; supply the password for the sa login at runtime. If you must store this password in a script file, secure the tệp tin khổng lồ prsự kiện unauthorized access. You should never use a blank sa password.
To enumerate all Squốc lộ Server 2000 (64-bit) instances without installing SP4. mở cửa the command prompt window & navigate lớn the location of the SP4 setup files. Type the following at the commvà prompt và press Enter: thiết đặt.exe pháo /reportonly Unattended Installation Considerations The following considerations relate khổng lồ unattended installations:. Run unattended installations using Windows Authentication whenever possible.
During an unattended installation, if Setup detects any non-writable databases or filegroups, that information is written to the Setup log & the unattended installation continues. If any of the non-writable databases listed in the Setup log are members of a replication topology, you must make those databases writable & reapply SP4 Setup lớn that instance of Squốc lộ Server 2000 (64-bit). For more information about making a database writable, see Section 3.6. For more information about reapplying SP4, see Section 3.8.
5.0 Documentation Notes This section covers issues that can occur after applying Database Components SP4 & new features that are available when you run SP4. These issues apply when running the service pack khổng lồ tăng cấp from any earlier version of Squốc lộ Server 2000. This section does not describe all of the fixes provided in SP4.
For a complete các mục of these fixes, see Microsoft Knowledge Base articles và. Any information relevant lớn Squốc lộ Server 2000 Service Paông chồng 4 that was not available in time to be included in this Readme file will be published in Microsoft Knowledge Base article.
5.1 Database Enhancements The following enhancements apply lớn instances of SQL Server 2000 on which Database Components SP4 is installed. 5.1.1 Change to lớn Maximum Network Packet Size Introduced in SP4 In SP4, the maximum value for the network packet kích thước option (mix using spconfigure) is 32767. This is slightly less than half the previous maximum of 65536. During tăng cấp, existing values larger than 32767 will automatically be adjusted khổng lồ 32767. If a script attempts khổng lồ use spconfigure to phối a value larger than 32767 but less than or equal to lớn 65536, the value will also be set lớn 32767. Setting the network packet kích thước khổng lồ a value larger than 65536 results in an error. 5.1.2 Optimization of Queries with Large IN Lists or Many OR Clauses Introduced in SP4 SP4 includes a change in the behavior of the Squốc lộ Server optimizer that affects queries containing predicates with large IN lists or many OR clauses.
Generally, a tải về manager enables downloading of large files or multiples files in one session. Many website browsers, such as Internet Explorer 9, include a tải về manager.
Stand-alone tải về managers also are available, including the Microsoft Download Manager. If you vì not have a tải về manager installed, & still want lớn tải về the file(s) you"ve sầu chosen, please note:. You may not be able lớn tải về multiple files at the same time. In this case, you will have to tải về the files individually. (You would have sầu the opportunity khổng lồ tải về individual files on the "Thank you for downloading" page after completing your download.). Files larger than 1 GB may take much longer khổng lồ tải về và might not download correctly.
You might not be able khổng lồ pause the active downloads or resume downloads that have sầu failed. The Microsoft Download Manager solves these potential problems. It gives you the ability to download multiple files at one time and tải về large files quickly and reliably. It also allows you to suspover active downloads and resume downloads that have sầu failed. Microsoft Download Manager is free & available for tải về now.
This tải về is for new installations only. If you already have an earlier version of MSDE and would like to lớn tăng cấp to MSDE 2000 Service Paông xã 3a (SP3a), you will need to use the. MSDE 2000 Release A is functionally equivalent khổng lồ SQL Server 2000 Desktop Engine SP3a except for the following:. New licensing agreement. Removal of the merge modules that can be used to embed MSDE 2000 Release A with applications.
New ReadMeMSDE2000A.htm that contains information specific to this release. This new version of MSDE contains all the fixes that are included with Squốc lộ Server 2000 SP3a version of MSDE. However, khổng lồ apply the most current security fixes, you will need to lớn tải về & install the. Supported Operating System Windows 2000, Windows 98, Windows ME, Windows NT, Windows Server 2003, Windows XPhường.
Intel Pentium or compatible 166-megahertz (MHz) or higher processor. 128 megabytes (MB) of RAM (Windows XP), 64 MB of RAM (Windows 2000), và 32MB of RAM for all other operating systems. 44 MB of available hard disk space Important cảnh báo Microsoft Squốc lộ Server Desktop Engine (MSDE) will not be supported on the Microsoft Vista operating system. If you plan khổng lồ build an application và redistribute a database with it, you should consider using instead. For more information, see the page on microsoft.com.
Steps lớn tải về and extract MSDE 2000 Release A:. Step 1: Download the MSDE2000A.exe pháo file by clicking save sầu button. If you clichồng open button, then you will be directly viewing the licensing agreement information as described in Step#2.
Note: MSDE2000A.exe is a self-extracting package that contains all the files required lớn install MSDE 2000 Release A. In addition it contains ReadMeMSDE2000A.htm that contains useful information about this release, including pre-requisites & step by step installation instructions. Step 2: Double Cliông xã the downloaded.exe cộ file, read through the licensing agreement information và if you accept the terms, clichồng the "I Agree" button. Step 3: You will be asked khổng lồ specify a directory where the files will be extracted. You can specify a directory that does not exist, the extracting process will detect & create the directory structure on your behalf.

Xem thêm: " Wander Là Gì ? Wander Là Gì, Nghĩa Của Từ Wander


Step 4: Once you have extracted the file, for installation prerequisites và instructions, open the ReadMeMSDE2000A.htm (this can be found in the root of the directory you specified in the above step#3).

Chuyên mục: Blockchain