Install SQL Server 2005 Service Pack 2 (SP2)
Now I need to install SQL 2005 SP2, so I launch SQLServer2005SP2-KB921896-x86-ENU.exe
by double-clicking on it from a VMWare shared folder, and click Run. I click Next on the Welcome page, accept the licensing agreement and click Next again. On the feature selection screen (see Figure 20
), I'll accept the defaults and click Next.
|Figure 20. SQL Server 2005 Service Pack 2 Setup: The Feature Selection screen shows the default components to be installed for SP2.|
The default values on the Authentication screen (see Figure 21
) seem fine, so again, I just click Next, and then click Next again to get past the error and usage reporting screen, leaving the boxes unchecked.
|Figure 21. SQL Server 2005 Service Pack 2 Setup: The screen shows the default Authentication options for SQL Server 2005 SP2.||
|Figure 22. SQL Server 2005 Service Pack 2 Setup: This screen lists running processes that you need to stop so SP2 can update files.||
The next screen checks for Running Processes (see Figure 22
), and lists Report Server, so I'll need to turn off that service. To do so right-click on My Computer, select the Manage option, open the Services and Applications node, and then click on Services. I highlight SQL Server Reporting Services and click on Stop the service (see Figure 23
|Figure 23. SQL Server 2005 Service Pack 2 Setup: You can stop running services by clicking the Services item in the Computer Management applet, selecting the process you want stop by clicking the Stop icon (the black square) on the toolbar.||
|Figure 24. SQL Server 2005 Service Pack 2 Setup: After stopping the ReportServer service, the Running Processes screen no longer shows any locked files.||
I then close the Computer Management window (if you neglect to close the window the Running Processes page will still show that process as running!), return to the SQL Server 2005 Service Pack 2 Setup window, and click Refresh. The updated screen verifies that no running processes will interfere with the update (see Figure 24
), so I click Next, and begin the install from the next screen to install the Service Pack for the relevant components.
After the Service Pack install completes (see Figure 25), I click Next, and then click Next once more from the Installation Complete screen.
|Figure 25. SQL Server 2005 Service Pack 2 Setup: The figure shows the Installation Process screen.|
Finally, I unclick the "Launch user provisioning tool
" and then click Finish
on the Additional Information screen.