[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
How to install SQL Server 2005 SP3

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

How to install SQL Server 2005 SP3


Applies to: Microsoft SQL Server 2005


Download SQL Server 2005 SP3.

Please download SQL Server 2005 SP3 from here.


Risk Analysis.

- After SQL Server 2005 SP3 has been applied, it cannot be removed without uninstalling SQL Server 2005 completely.
- Test it on a test environment.
- Contact vendors of third-party software using your database server and get their approval.


Requirements.

- Use windows authentication instead of SQL Server Authentication when applying SP3.
- The windows account used to run the SP3 setup program must have administrator privileges on the computer where SP3 will be installed.
- Disk space needed for the installation:

Permanent 50 MB - SQL Server installation directory
1 GB - System drive
At least 500 KB of free space on system databases (better if you set autogrow on)
Temporary 600 MB - Temp Directory
334 MB - SP3 package. Remove it after applying SP3


Pre-installation tasks.

- Backup system databases.
- Backup user databases.
- Back up your Analysis Services databases, configuration file, and repository.
- Pause mirroring.
- Enable named pipes on your SQL Server 2005 server.
- Disable DDL Triggers.
- Verify that SQL Server 2005 Service Accounts are not disabled.
- Resources that have dependencies on SQL Server resources must be removed or taken offline prior applying SP3 .
- Stop all applications and services that make connections to the instance being upgraded. You cannot stop services in a failover cluster environment.

In case of a failover cluster environment, configure Microsoft Distributed Transaction Coordinator on the cluster.  Also, verify the following services are running on both nodes:

- Task Scheduler
- Com+ System Application Service
- Cryptographic Services
- Remote Registry Service
- Server


Installation.

In case of a failover cluster environment, please consider the following:

- Do not stop the cluster service during installation or before applying SP3.
- Do not stop any running processes before running SP3 Setup.


Normal (non-clustered) installation:

- To install SQL Server 2005 SP3, run the self-extracting package file. Run SP3 Setup.
- After applying SP3, install cumulative update package 1 for SQL Server 2005 Service Pack 3


Installing SP3 on a failover cluster environment:

- Run SP3 Setup on the active node.
- After applying SP3, install cumulative update package 1 for SQL Server 2005 Service Pack 3 on the active node.


Post-installation Tasks.

- Restart each node of the cluster.
- Restart services that have dependencies on SQL Server.
- Verify proper operation of client applications.
- Backup system databases after successful installation.
- If the cluster was using mixed mode authentication, please verify it was not changed to Windows Authentication. Click here for more information.



References.


1) Microsoft SQL Server 2005 SP3 Release Notes.
2) SQL Server 2005 SP3 sqlHotFix.chm file
3) What's New in SQL Server 2005 SP3
 


 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.