Reloading agent settings issue in SQL Server 2012

In case you are getting bunch of following message “Reloading agent settings” in sql server Agent error log, you can fix it by small fix in registry setting. Go to registry on your SQL Server machine and go to following. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ MSSQL11.YOUR_INSTANCE_NAME\SQLServerAgent Now change “AutoRegistryRefresh” from 1 to 0 and restart the SQL […]