{"id":4268,"date":"2020-06-29T08:37:37","date_gmt":"2020-06-29T06:37:37","guid":{"rendered":"https:\/\/www.msb365.blog\/?p=4268"},"modified":"2023-06-23T13:03:08","modified_gmt":"2023-06-23T11:03:08","slug":"sophos-astaro-office-fail","status":"publish","type":"post","link":"https:\/\/www.msb365.blog\/?p=4268","title":{"rendered":"Office 365 Ports and Firewall Challenges"},"content":{"rendered":"<p>In this article I would like to talk about the deployment of Office 365.<br \/>\nWe can prepare, automate, customize, etc. a lot in our Microsoft Admin Portals.<\/p>\n<p>Nevertheless, it happens again and again that parts of the service do not work. My experience has shown me that in more than 90% of the cases, one of these 2 points was responsible.<\/p>\n<p>&nbsp;<\/p>\n<h3>Firewall exceptions<\/h3>\n<p>During one of my last installations we deployed Microsoft 365 via autopilot. This basically worked very well. Only the office package could not be installed.<\/p>\n<p>In another case, the Office applications were already installed, but could not be updated.<\/p>\n<p>Both customers had one general thing in common. This was the used firewall. In this case we are talking about Sophos Astaro UTM.<br \/>\nI am not saying that this problem can only occur with a Sophos UTM firewalls, but in my example I am using that firewall.<\/p>\n<p>The reason why Office could not be installed is that the firewall requires an exception.<br \/>\nHere is how this can be done:<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/00.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-4269\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/00.png\" alt=\"\" width=\"996\" height=\"593\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/00.png 996w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/00-300x179.png 300w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/00-768x457.png 768w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/00-600x357.png 600w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/00-905x539.png 905w\" sizes=\"(max-width: 996px) 100vw, 996px\" \/><\/a><\/td>\n<td width=\"301\">We logged on to the Sophos Firewall.<\/td>\n<\/tr>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/01.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4270\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/01.png\" alt=\"\" width=\"229\" height=\"300\" \/><\/a><\/td>\n<td width=\"301\">After the successful logon we browse to:<\/p>\n<p><strong>Web Protection<\/strong> &gt; <strong>Filtering Options<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/02.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4271\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/02.png\" alt=\"\" width=\"385\" height=\"231\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/02.png 385w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/02-300x180.png 300w\" sizes=\"(max-width: 385px) 100vw, 385px\" \/><\/a><\/td>\n<td width=\"301\">Here we click on<\/p>\n<p><strong>+New Exeption List&#8230;<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4272\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/03.png\" alt=\"\" width=\"379\" height=\"838\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/03.png 379w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/03-136x300.png 136w\" sizes=\"(max-width: 379px) 100vw, 379px\" \/><\/a><\/td>\n<td width=\"301\">Then we create a new exception according to the template in the picture.<\/p>\n<p>Of course, individual settings can be adjusted according to the infrastructure. But I recommend using this configuration whenever possible.<\/p>\n<p>The most important step is the &#8220;Target Zone&#8221;. Here we define the domains for which we want to do the excluding.<\/p>\n<p>In our case we need the following value:<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>^https?:\/\/([A-Za-z0-9.-]*\\.)?officecdn\\.microsoft\\.com\\.edgesuite\\.net\/<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>At the end confirm with <strong>Save<\/strong>, and the new exeption is ready.<\/td>\n<\/tr>\n<tr>\n<td width=\"301\"><a href=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4273\" src=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/04.png\" alt=\"\" width=\"776\" height=\"126\" srcset=\"https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/04.png 776w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/04-300x49.png 300w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/04-768x125.png 768w, https:\/\/msb365.abstergo.ch\/wp-content\/uploads\/2020\/06\/04-600x97.png 600w\" sizes=\"(max-width: 776px) 100vw, 776px\" \/><\/a><\/td>\n<td width=\"301\">This is what the created exception will look like on Sophos.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Note: Please note that this is only an example with a Sophos Astaro Firewall. Other vendors with similar issues will have similar procedures. What matters most is the information that this must be taken and what value we must use to make it work.<\/p>\n<p>&nbsp;<\/p>\n<h3>General Firewall Ports<\/h3>\n<p>Another possible reason for service problems with Office 365 can be the classic firewall ports.<br \/>\nI have already described the ports for Exchange and Skype for Business in more detail in a <a href=\"https:\/\/www.msb365.blog\/?p=4099\" target=\"_blank\" rel=\"noopener noreferrer\">previous article<\/a>.<\/p>\n<p>In this part of my blog article I would like to keep it a bit more general, but you will still recognize some entries in the following list:<\/p>\n<table width=\"497\">\n<tbody>\n<tr>\n<td width=\"215\">Server\/Service<\/td>\n<td width=\"108\">Port<\/td>\n<td width=\"58\">Protocol<\/td>\n<td width=\"116\">Direction<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">ADFS\u00a0\u00a0 (Internal)<\/td>\n<td width=\"108\">443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">ADFS (Proxy DMZ) or WAP Server<\/td>\n<td width=\"108\">443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Microsoft Online Portal (Website)<\/td>\n<td width=\"108\">443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Outlook Web Access (Website)<\/td>\n<td width=\"108\">443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Lync\/Skype for Business Client<\/td>\n<td width=\"108\">443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">SharePoint Online (Website)<\/td>\n<td width=\"108\">443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Outlook for Mac<\/td>\n<td width=\"108\">443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Outlook Client<\/td>\n<td width=\"108\">443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Mail Routing<\/td>\n<td width=\"108\">25<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">SMTP Relay (requires TLS)<\/td>\n<td width=\"108\">587<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Simple IMAP4 migration Tool<\/td>\n<td width=\"108\">143\/993<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">POP3 (requires SSL)<\/td>\n<td width=\"108\">995<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">DirSync\/Azure Active Directory Sync<\/td>\n<td width=\"108\">80\/443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Exchange Migration Tool<\/td>\n<td width=\"108\">80\/443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">IMAP Migration Tool<\/td>\n<td width=\"108\">80\/443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Exchange Management Console<\/td>\n<td width=\"108\">80\/443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Exchange Management Shell<\/td>\n<td width=\"108\">80\/443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Inbound\/Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Lync (Data Sharing Sessions)<\/td>\n<td width=\"108\">443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Lync (Video, Audio, Application Sharing)<\/td>\n<td width=\"108\">443<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Lync (Audio &amp; Video)<\/td>\n<td width=\"108\">3478<\/td>\n<td width=\"58\">UDP<\/td>\n<td width=\"116\">Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Lync (Audio &amp; Video)<\/td>\n<td width=\"108\">50000-59999<\/td>\n<td width=\"58\">TCP\/UDP<\/td>\n<td width=\"116\">Outbound<\/td>\n<\/tr>\n<tr>\n<td width=\"215\">Lync Mobile Push iOS Only<\/td>\n<td width=\"108\">5223<\/td>\n<td width=\"58\">TCP<\/td>\n<td width=\"116\">Outbound<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h3>Conclution<\/h3>\n<p>As mentioned at the beginning of this article, these two chapters in this article cover over 90% of the problems that occur when Office 365 installations or updates fail.<br \/>\nI hope this article has helped some of them.<\/p>\n<p>&nbsp;<\/p>\n<p>Photo by <a href=\"https:\/\/unsplash.com\/@maud_boc?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText\">Maud Bocquillod<\/a> on <a href=\"\/s\/photos\/bridge-fog?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText\">Unsplash<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article I would like to talk about the deployment of Office 365. We can prepare, automate, customize, etc. a lot in our Microsoft Admin Portals. Nevertheless, it happens again and again that parts of the service do not work. My experience has shown me that in more than 90% of the cases, one [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4279,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1923],"tags":[],"class_list":["post-4268","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-365"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/posts\/4268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4268"}],"version-history":[{"count":7,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/posts\/4268\/revisions"}],"predecessor-version":[{"id":5173,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/posts\/4268\/revisions\/5173"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=\/wp\/v2\/media\/4279"}],"wp:attachment":[{"href":"https:\/\/www.msb365.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.msb365.blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}