SMA Management Pack Could Not Connect To Database Alerts – My Troubleshooting Experience

I’ve setup 2 servers for the SMA environment in my lab a while back. Yesterday, I loaded the SMA MP (version 7.2.89.0) into my OpsMgr management group. Needless to say, I followed the MP guide and configured the Database RunAs profile. However, soon after the MP is loaded, I started getting these 2 alerts: The Service Management Automation web service could not connect to the database. The Service Management Automation worker server could not connect to the database. To troubleshoot these alerts, I firstly unsealed the management pack Microsoft.SystemCenter.ServiceManagementAutomation.2012R2.mp, as this is where the monitors are coming from. The Data

Continue reading

SMA Runbook: Update A SharePoint 2013 List Item

Background This blog hasn’t been too active lately. I’ve been spending a lot of time learning the new member in System Center family: Service Management Automation. Yesterday, I needed a SMA runbook to update SharePoint 2013 list items, I found a sample from a blog post by Christian Booth, which contains a SMA runbook written by Ryan Andorfer, a System Center Cloud and Datacenter MVP.  Looks Ryan’s code was written for SharePoint 2010, which does not work for SharePoint 2013 because the SharePoint REST API has been updated. So I have spent some time, learned a bit more about SharePoint

Continue reading
%d bloggers like this: