Once the SQL Server 2005 instance is installed, the next step should be installing the latest service pack. As such, below outlines the steps to complete the SQL Server 2005 Service Pack 1 installation.
ID
Directions
Screenshot
1
Download – Reference this URL to download the SQL Server 2005 Service Pack 1.
Open File – Run the file by clicking the 'Run' button.
3
Extracting Files – The files will extract to a temporary location.
4
Welcome – The service pack can update the features listed.
Press the 'Next' button to proceed.
5
End User License Agreement – Review the End User License Agreement (EULA) and once complete select the 'I accept the licensing terms and conditions' check box.
This acceptance will activate the 'Next' button, so click this button to proceed.
6
Feature Selection – Select the features that you want to update by clicking the check boxes.
Press the 'Next' button to proceed.
7
Authentication Mode – Select the authentication as either Windows or SQL Server for all instances and services or setup the authentication for specific instances.
Press the 'Next' button to proceed.
8
Ready to Install - Press the 'Install' button to begin the service pack installation.
9
Installation Progress – Review the installations as they complete.
Press the 'Next' button to proceed.
10
Installation Complete – Review the status for each installation to ensure the status is 'Success.'
Click the 'View Log File' button to review the detailed status of the installation.
11
Log File – Review the log file for detailed installation steps and output.
Close this file and return to the previous screen. To end the installation process, click the 'Finish' button.
Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. He is the author of the Rational Guide to IT Project Management. Jeremy is also the SearchSQLServer.com Performance Tuning expert. Ask him a question here. Copyright 2006TechTarget
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.
Home: 
