SQL Server 2012 SP1 – MsiInstaller is going crazy!

Woah! I just installed SQL Server 2012 SP1 and MsiInstaller is attempting to reconfigure management studio constantly!

Event Viewer: Windows Installer reconfigured the product. Product Name: SQL Server 2012 Management Studio. Product Version: 11.1.3000.0. Product Language: 1033. Manufacturer: Microsoft Corporation. Reconfiguration success or error status: 0.

If this is happening to you, the good news is, there is a hotfix. I have had this happen on one of my SQL 2012 SP1 VMs, but I haven’t been able to exactly replicate how the issue came about. The issue has more documentation on Connect, and is resolved by requesting SQL Server SP1 CU2.

Reloading Agent Settings in SQL Agent Logs

Update:  This issue is resolved as of SQL Server 2012 SP1, which can be downloaded here.

After upgrading to SQL Server 2012, you may notice that your SQL Agent Log is sprinkled with “Reloading agent settings” every 90 seconds.  This does not appear to be harmful as this is just the automatic registry refresh.  However, this can be painful if you have set up log monitoring.  Until this is resolved, the workaround as detailed on Connect is to update your registry to disable the auto refresh.  The downside here is that if you change any of the default agent settings, you may need to restart agent for them to take effect.

Go to registry on your SQL Server machine and navigate to corresponding SQL Instance registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ MSSQL11.YOUR_INSTANCE_NAME\SQLServerAgent
Change registry settings called “AutoRegistryRefresh” from 1 to 0.