SCSM 2012: Management Servers might not reconnect to SQL after a SQL outage
Kevin Holman blogged about this issue for SCOM 2012 but many of our customers don’t know that it is also applicable to SCSM 2012 as well. It is one of the most frequent issues we find in our SCSM RAP as a Service offering here in Microsoft.
The issue is documented here: https://support.microsoft.com/kb/2913046/en-us
For each of your SCSM Management Servers and your DW Management Server please create the registry keys as Kevin show’s in his blog post: https://blogs.technet.com/b/kevinholman/archive/2014/03/12/opsmgr-2012-management-servers-might-not-reconnect-to-sql-after-a-sql-outage.aspx