We tried applying the SP3 patch for Sql Server 2005 (Clustered Environment) and it was failing with the following message:
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
Error Number : 29512
Error Description : MSP Error: 29512 SQL Server Setup was unable add user firstname.lastname@example.org to local group ACS-ESG1\ADASQLDB1_Agent.
Does anyone know if it's acceptable to detach our application databases while performing the SP3 upgrade? We were experiencing issues with processes trying attach while performing the upgrade and we just want to make sure that everything is locked down.
Please share your thoughts and expertise to help us through this bumpy upgrade.