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
%d bloggers like this: