SP4 on SQL Server 2005 Fails
- On the active node, use failover cluster manager to pause all passive nodes
- On the active node, run and complete the SQL 2005 SP4 installation
- On the active node, use failover cluster manager to resume all previously paused nodes
- On all passive nodes, run and complete the SQL 2005 SP4 installation using the /passive command line switch
- Reboot all node
This will ensue that any necessary system databases are updated as well, as opposed to only the binaries. This can be verified using the sql code below:
SELECT SERVERPROPERTY('productversion') as [SQL Version],
SERVERPROPERTY('productlevel') as [level],
SERVERPROPERTY('edition') as edition,
SERVERPROPERTY('resourceversion') as [Resource Version]
SERVERPROPERTY('productlevel') as [level],
SERVERPROPERTY('edition') as edition,
SERVERPROPERTY('resourceversion') as [Resource Version]