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:

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.