Installing of SCOM 2012 has some requirements and one of them being SQL. I ran the install for SQL and when I tried to install SP1 for SQL 2008 R2 it failed with the following error:

  • ” A failure was detected for a previous installation, patch, or repair for instance ‘MSSQLSERVER’. In order to apply this patch package, you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.”

So I went to Programs and Features and ran a repair on SQL. Upon getting to 80% of the repair it gave this error:

  • “The following error has occurred: The process cannot access the file ‘C:Windowssystem32perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll’ because it is being used by another process.
  • Click ‘Retry’ to retry the failed action, or click ‘Cancel’ to cancel this action and continue setup.”

So I checked and all services were stopped. The fix is to stop the Windows Management Intrumentation Service and all the dependencies. After that the repair will go through successfully and you will now be able to install SP1 for SQL.

Hope it helps