Cool Dashboard in recent SQL 2012 MP
- Microsoft has released a pretty cool dashboard in recent SQL 2012 MP.
- It gives awesome dashbaord view for the team to Monitoring and know you database perforamnce from single console
- To Download latest MP click here --> Download
SCOM Data access Service and Config Service failing to start after recent SCCM Patching
- After recent SCCM patching window where the SCOM servers got patched, i got a call from support team that the SCOM Data access service (SDK service) and Config Service are not starting.
- Further investigation revealed that a particular patch KB2677070 was causing the issue as it was trying to access the intenet to check on revoked trusted certificates.
- As most corporate enviorment internet is blocked from prouction servers this started faining can caused the service not to start.
- After uninstall the patch and reboot the server, the services started without any issue.
- Another solution is that you have go to th registry
- HKLM\Software\Policies\Microsoft\SystemCertificates
- Right-click AuthRoot, select New, and then click DWORD.
- Type DisableRootAutoUpdate, and then press Enter.
- Right-click DisableRootAutoUpdate, and then click Modify.
- In the Value data box, type 1, and then click OK.
