Saturday, January 19, 2013

MSIInstaller Application Log Entries Fix - SQL Server 2012 SP1

If you are SQL Server 2012 is running with SP1 (11.0.3000) you may encounter the below error messages in the windows application event log and it may cause high cpu pressure on the machine

In Windows Event Viewer

SQL_Tools_ANS component failed, The resource doesn't exist
SQL_Tools_ANS failed during request for component
Event ID 1004 MSIInstaller / Detection of Product {xxxxxx} feature
Event ID 1040 MSIInstaller / Beginning a windows installer transaction {xxxxxxxxx}
Event ID 1042 MSIInstaller / Ending a windows installer transaction {xxxxxxxxx}


Please install CU1 on top of SQL Server 2012 SP1, Build No - 11.0.3128 will fix the MSIInstaller issue and high cpu issue.

No comments: