{"id":2431,"date":"2013-09-13T18:44:00","date_gmt":"2013-09-13T18:44:00","guid":{"rendered":"http:\/\/riguy.azurewebsites.net\/?p=2431"},"modified":"2014-12-19T01:56:06","modified_gmt":"2014-12-19T01:56:06","slug":"sql-exchange-services-stop-after-windows-server-2008-updates","status":"publish","type":"post","link":"https:\/\/riguy.com\/?p=2431","title":{"rendered":"SQL + Exchange Services Stop After Windows Server 2008 Updates"},"content":{"rendered":"<p>Rookie Mistake, even though I am an IT &#8216;veteran&#8217;.<\/p>\n<p>As a Systems Administrator, I am always trying to time Windows Automatic Updates perfectly. It&#8217;s one thing to install updates on a solo PC, laptop, or tablet. You manually click the Automatic Updates, sit there and watch&nbsp;them install, and hopefully they go smoothly. These days, Windows updates usually do go smoothly.&nbsp;But for a mid sized or large company or organization, these need to be automated. It is the same in a UNIX, Linux or other environment. <\/p>\n<p>Without going into detail, Windows Updates can be automated via a tool called WSUS. The updates are downloaded to a central server and from there, via group policies, they are pushed out to the local domain servers and workstations. Usually&nbsp; a reboot is involved, which can be scary on critical servers. It also can be a sweaty experience!<\/p>\n<p>Of course, in a perfect world a networked and domain environment would be duplicated in a test environment. Like I typed, &#8216;a perfect world&#8217;. It is easier said than done, and some companies do not allocate resources for a test environment. These companies, oddly enough, rely entirely on MICROSOFT ENGINEERS to test Windows updates properly before pushing them out to the world! But I digress &#8230;<\/p>\n<p>The Rookie Mistake was entirely on me. I properly had spread out the Updates via my WSUS server. Workstations on 1 day, then Member Servers over the Weekend, spread apart from the DC&#8217;s time frame.&nbsp;I would check alerts to verify all servers came back online and services were up etc. Any Sys Admin knows ugly Netlogon and other errors can be generated as a DC reboots. Member servers start to panic when they cannot contact Active Directory and security related services. Because the Windows Domain Controller holds the keys to the Kingdom, it is imperative that a DC be active during restarts.<\/p>\n<p>So, the point: One key item possibly overlooked by some administrators: separate Domain Controller and Member Server Group Policies, especially&nbsp;regarding update schedules. <\/p>\n<p>I had done this initially but one day, carelessly, I was trying to get the DC updates done at a different time for&nbsp;scheduling purposes. The reason was that I wanted them done closer to the morning so I could fix quicker if there was indeed an issue. In my infinite (non) wisdom, I erroneously scheduled the new day + time for automated updates to be exactly the same&nbsp;as the schedule for the member servers. Again, this may seem fine on the surface, but again, certain services from member servers NEED to contact a domain controller continuously in order to start successfully. Exchange 2010 and SQL 2008 come to mind! Services like SQL Server and Exchange&#8217;s Information Store will literally STOP if there is no contact with a Domain Controller, but mainly when there are simultaneous reboots amongst all DC s and Member servers. <\/p>\n<p>So, do not forget to schedule Domain Controller Windows Updates at least 1 hour apart from Member server updates. Brief reboots of&nbsp;the DC (s) while Member Servers are running are OK, but simultaneous reboots can be problematic. And always have services alerts running, in case there is a problem. I use Netikus Event Sentry for this (it is a solid product), and you can weed out the non critical services from the critical. <\/p>\n<p>I readjusted the schedule to separate the Updates again, and &#8230; lesson (re) learned!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Rookie Mistake, even though I am an IT &#8216;veteran&#8217;. As a Systems Administrator, I am always trying to time Windows Automatic Updates perfectly. It&#8217;s one thing to install updates on a solo PC, laptop, or tablet. You manually click the Automatic Updates, sit there and watch&nbsp;them install, and hopefully they go smoothly. These days, Windows &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/riguy.com\/?p=2431\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;SQL + Exchange Services Stop After Windows Server 2008 Updates&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-2431","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/riguy.com\/index.php?rest_route=\/wp\/v2\/posts\/2431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/riguy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/riguy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/riguy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/riguy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2431"}],"version-history":[{"count":0,"href":"https:\/\/riguy.com\/index.php?rest_route=\/wp\/v2\/posts\/2431\/revisions"}],"wp:attachment":[{"href":"https:\/\/riguy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/riguy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/riguy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}