Step-by-Step Guide

Install SQL Server Service Pack 1

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.

    Requires Free Membership to View

Service Pack 1
2 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.

Installing a SQL Server 2005 Instance

 Home: Introduction
 Step 1: Begin your SQL Server instance installation
 Step 2: Choose SQL Server installation components
 Step 3: Specify account, authentication mode and settings
 Step 4: Click 'Install' and review your summary log
 Step 5: Install SQL Server Service Pack 1

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 Performance Tuning expert. Ask him a question here.
Copyright 2006 TechTarget

This was first published in December 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: