How to Install SQL Server 2000 Service Pack 4
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
Follow these steps to install Microsoft SQL Server 2000 Service Pack 4. This service pack is cluster-aware. Therefore, you do not have to install it on both computers that are running SQL Server. This installation involves downloading and installing the service pack, and then running the service pack wizard.
To install SQL Server 2000 Service Pack 4
Verify that the computer that is running SQL Server is on. If your deployment involves clustered computers that are running SQL Server, verify that both computers that are running SQL Server are on.
By using a browser, locate the SQL Server 2000 Service Pack 4 download page at https://go.microsoft.com/fwlink/?LinkId=56730.
On the SQL Server 2000 Service Pack 4 page, click Download files below, and then click SQL2000-KB884525-SP4-x86.EXE.
In the File Download dialog box, click Save.
In the Save As dialog box, specify a folder for saving the service pack set up file, and then click Save.
Click Start, click Run, type Explorer, and then click OK.
In Windows Explorer, locate the folder (specified in step 5) where you saved the service pack set up file, and then double-click SQL2000-KB884525-SP4-x86.EXE.
In the Installation Folder dialog box, in the Installation Folder box, type the path of a folder for extracting the service pack files, or click Browse to find a folder, and then click Finish.
To run the service pack wizard
Click Start, click Run, type Explorer, and then click OK.
In Windows Explorer, locate the folder (specified in step 8 earlier) where you extracted the service pack files, and then run the set up file (setup.bat).
On the Welcome to the Microsoft SQL Server 2000 Service Pack 4 Installation Wizard page, click Next.
On the Computer Name page, select Virtual Server, type the virtual server name, for example, SQLCLUSTER, and then click Next.
On the Software License Agreement page, click Yes.
On the Instance Name page, click Next.
On the Remote Information page, type Admin for the cluster, and then click Next.
On the Connect to Server page, select Windows authentication, and then click Next.
In the SA Password Warning dialog box, select Ignore the security threat warning, leave the password blank, and then click Next.
In the SQL Server 2000 Service Pack 4 Setup dialog box, select Upgrade Microsoft Search and apply SQL Server 2000 SP4, and then click Continue.
In the SQL Server 2000 Service Pack 4 Setup dialog box, make sure that the check box for Enable cross-database ownership chaining for all databases is clear, and then click Continue.
In the Error Reporting dialog box, click OK.
On the Remote Informationpage, do the following:
Use this
To do this
Username
Type CLUSvc.
Password
Type the corresponding password.
Domain
Type the domain name.
Click Next.
In the dialog box warning you to back up your databases, click OK.
On the Start Copying Files page, click Next.
On the Shutting Down Tasks page, click Next.
The installation process starts.
In the Setup dialog box, click OK.
On the Setup Complete page, select Yes, I want to restart my computer now, and then click Finish.
For clustered deployments, restart the second computer that is running SQL Server only after the first computer that is running SQL Server has fully restarted. You might experience database corruption if you do not wait until the first computer that is running SQL Server has fully restarted before restarting the second computer that is running SQL Server.
See Also
Other Resources
Configuring the Business Management Server