Owner's Manual

Deployment Guide 33
29 If you are instructed to restart the computer, do so now. Be sure to read the message from the Setup
program when you complete the installation.
NOTE: Failure to restart the computer may cause failures when you run the Setup program in the future.
Installing Service Pack 2 for the SQL Server 2005 Database
1 Close all applications before proceeding.
2 Right-click My Computer and select Manage .
3 Expand Services and Applications .
4 Select Services .
5 In the Services window, stop all SQL Server services:
a Right-click the services that begin with SQL Server and that have a status of Started
b Select Stop .
NOTE: If you are installing SQL SP2 on a cluster setup, stop the Cluster Service.
6 Insert the SQL Server 2005 SP2 CD into the CD drive.
7 Double-click the SQL Server 2005 SP2 executable to start the install.
8 In the Welcome page, click Next .
9 In the End User License Agreement page, read the license agreement; select the check box to accept
the License Terms agreement and click
Next .
10 In the Feature Selection page, accept the defaults and click Next .
11 In the Authentication page, select the authentication mode you selected for SQL Server 2005 during
the installation and click
Next .
NOTE: If you select the SQL Server Authentication mode, enter the sa password you entered in step 19 of
"Installing the SQL Server 2005 Database Software" on page 30. In case of cluster, enter the domain user
credentials on the Remote User Account page.
The Remote User Account page will appear if it is a cluster configuration. Type the user information that
has been configured to run the cluster service.
12
Accept the defaults in the Error and Usage Reporting Settings window and click Next .
13 The Running Processes page lists the processes that are locking files required for the SP2 update.
NOTE: If any files are listed here, then a Reboot is required after installing SP2.
14 In the Ready to Install page, click Install .
15 If a Computer Reboot Required message displays, click OK in the message box.
16 In the Installation Process page, click Next .
17 In the Installation Complete page, click Next .
NOTE: In cluster configurations, SQL SP2 needs to be installed on each node.